asp.net - Change the driver in the connection string to a data source in VB.Net -
I have a code that has a driver in a connection string. as a slow string = "driver = {SQL Server}; server = xxx \ SQLEXPRESS; database = dbRegister; reliable connection = yes" I need to change it: data source = 1.2.3.4; User ID = xx; Password = xxxxx; Initial list = xxxxx; Connect timeout = 30 " When I change text, it returns this error: [microsoft] [ ODBC] Driver Manager] The name of the data source was not found and no default driver specified How do I declare a data source? myServerAddress; Initial Catalog = myDataBase; User id = myUsername; Password = myPassword; Use the server name \ example to connect to the specific SQL Server instance as the data source. Are you using SQL Server 2005 Express? Server name syntax does not remember Servername \ SQLEXPRESS Visit P>
Comments
Post a Comment