Using datasource wizard with vb express & SQL 2000

[diverdan]

Hi there

I am trying to use the wizard to setup a datasource between an sql database using vb express.

I am not able to do so and its due to the connection string that the wizard is creating.

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Program Files\Microsoft SQL Server\MSSQL\Data\ActionGlass_Data.MDF";User ID=sa;Connect Timeout=30;User Instance=True

Is the string its creating but I am not using sqlexpress.


How can I can the wizard to work correctly.

Thanks for your help!!

 

[fpineda101]

You can try coding in the objects needed for the connection instead of using the ToolBox components. I find it easier for me that way.

Be sure to import system.data.sqlclient or
import system.data.oledbclient or
import system.data.oracleclient if using oracle.

Go to www.connectionstrings.com for your connection string.