How do I strip out the data source from the connection string so that I only have the directory path and file name.
My connection string is thus:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Documents and SettingsMartinMy DocumentsVisual Studio 2008ProjectsRestelRestel IIRestel IIRestel.mdb
I developed a winform application and I want to send the .exe file to someone else. That means that my datasource for my connection string is not the same any more
Dim da As OleDbDataAdapter
Dim dt As New DataSet
Dim objConnection As OleDbConnection = New OleDb.OleDbConnection
[Code]....
i have a code which has the connection string as driver. dim s as string = "Driver={SQL Server}; Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes" i need to change that to - "data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30" when i just change the text it gives this error - "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" how do i declare the datasource?
View 2 Repliesi have a code which has the connection string as driver.dim s as string = "Drr={SQL Server};Server=xxxSQLEXPRESS; Database=dbRegister; Trusted_Connection=yes"i need to change that to"data source=1.2.3.4;user id=xx;password=xxxxx;initial catalog=xxxxx;Connect Timeout=30"hen i just change the text it gives this error -"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"
View 13 RepliesI am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesI have a project where I added visually and successfully a datasource of MySql. I binded a datagridview with a table.
But, how do I change programatically the password, ip or user to connect with the MySql server? Because it can change at any time, so I can let the user change these values.
I have created a data source connection to an access db by using the wizard in vs2008. I have then used this as a data source for crystal reports. My user would like to put the database on a network and reference it there. Is there a way to set a new path for this data source during runtime?
View 4 RepliesWe are going to change the connection string in Settings.vb so we don't need to worry about what it is when our app runs on a different computer other than the development computer.
[Code]...
I have been trying for days now how to create a process to the user to easily create a connection to any installed data types they have installed. I have found an example right inside vb2008. I never use this because I code my own connections, but this would be real nice if I could include it or duplicate it.
View 1 RepliesMy program so far reads a certain webpage's source code and places it in a textbox. This much has already been accomplished.
Now I need to pick certain strings out of the rather large amount of text data and have the lines stored in variables, but the trick of it is, the exact string is unknown. The exact function should be, that the code finds certain tags from the source code, say <td> and </td> and takes the string data in between those tags, what ever it may be.
I got this Error Message while I try to preview the records in Dataset Designer:"The connection string could not be found or Data provider associated with the connection string could not be loaded"
Here is my dataset.xsd code
<Connections>
<Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="loginConnectionString1" IsAppSettingsProperty="true" Modifier="Assembly" Name="loginConnectionString1 (MySettings)"
[code]....
I need code for opening DB connection using an ODBC data source. then I need to get some data from there to a data set.
View 7 RepliesI need to strip every other char from an array or string. Whichever is easier.
View 4 Replieshow to strip html code from a string? I know how to do this in Visual Basic 6 using Regular Expressions 5.5 as a reference, but since I switched to VB.NET 2008 today, I am quite unaware on how to do the same.
View 2 RepliesThe problem consists that I would like to use WYD_RCON for Counter-Strike: Source!
Here initial Project:
WYD_RCON.rar
Works only on COD 4 and CS 1.6 (((
I have a simple scraper. It works on some websites, but on some there is this Error:
Quote:
IOException was unhandled Unable to read data from the transport connection: The connection was closed
It is occuring at "Dim htmlresults As String = Urlcontents.ReadToEnd()".
'Create the HttpWebRequest object
Dim req As HttpWebRequest = WebRequest.Create(URL)
'Set the timeout to 1 second (or 1,000 milliseconds)
req.Timeout = 10000
[code]....
How do I assign a My.Settings.Item connection string to cmd.Connection connection string value?
Dim cmd As New SqlCommand()
cmd.Connection = My.Settings.Item("csStaffHoursWorked")
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "spSaveDeltekImport"
I'm just trying to implement a 'no duplicates' catch on my insert customer form, but it just slips through my if statement to the else everytime. This is the source. Also I tried a .Equals with the same results :(
Protected Sub srcAllClients_Inserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles srcAllClients.Inserting
[Code].....
I need a connection string for connecting database. I have already used the connection string following.
connStr= "Provider=MSDASQL;Driver={Microsoft Access Driver (*.mdb)};DBQ=c:\mydb.mdb;Data Source=SampleDSN";
But, I got error as "Data source not found and no default driver specified".
[URL]
i have inherited some code form another developer who is using entityClient for a connection string. the web config entry looks like:
<add name="my_TESTEntities" connectionString="metadata=res://*/TEST.csdl|res://*/TEST.ssdl|res://*/TEST.msl;provider=System.Data.SqlClient;provider connection string="Data Source=myServer;Initial Catalog=TEST2;User ID=user_gg;Password=Aasdfasfasf;MultipleActiveResultSets=True"" providerName="System.Data.EntityClient"/>
what are the metadata files? i found them in the debug folder of the code i was given, do i need to point to them? do i need to move them somewhere else?
can data reader be used as a data source for a grid control?
View 5 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)
I refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI have a Web Browser and I have a button where I can get the HTML Source of a Web Page. The code I have so far stores the HTML Source in a string:
[Code]...
i can parse html source code and regex a few things, but i know the exact phrase i'm looking for do i still need a regex if i know what i'm looking for?
if (string = logged) then
do the code if 'logged' is found in the html source
else
[code]....
I've always used this approach while implementing data layer DLL for web application:
1) put datasets into the dll project
2) use a helper class with a method like this:
public shared sub settCnnStr(strconnhere as string)
My.Settings.Item("connectionString") = strconnhere
end sub
3) when I need to use the dll I call a method like this (usually into global.asax):
xxxxxxx.helper.setCnnStr("yyyyyyyyyyyyyy")
This method always worked for me nicely but I'd like to know if this method could have serious drawback or if there's a better solution.
I had a job interview today where I was asked to build a GUI for an MS Access 2003 database using VB.Net 2008 and old ADO. I looked on [URL] to find the correct one and I wasn't sure given the diverse development environment.
View 2 RepliesWhen i start computer or after restarting the first time when i open my program show this message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.What is problem here is connection string.vb.net
Public conn As New SqlConnection("Data Source=.SQLEXPRESS1;Initial Catalog=PesniDB;Integrated Security=SSPI")
I have a program on my machine that uses a local SQL Express 2005 database to store information in when the program is running. I want to use some data within said database in my program but for the life of me I cannot seem to get started by adding it as a new data source using the add data source wizard... If I type in the database name it throws an error that it cannot find the database, although I can quite clearly see it using the SQL Express 2005 SQL Server Management Tool.
View 7 RepliesThe code below works well to load an Excel file into a DataGridView. The menu 'Show Data Source' reveals there is no data source available. Is there a way to set up a data source much in the same way as is possible with a .mdb which I would normally add with the menu 'Add New Data'? Several ways to confugure the DataGridView are not options without a known data source.
Public Class Form1
Private da As New OleDb.OleDbDataAdapter
Private ds As New DataSet
[code].....
