attach db and sql express (2000 and vb 6.0)

[sal21]

in other (google site) i have see when the pregrammer use the string connection for sql express and vb it use the statement ATTACH .... ecc
but why i must use the tipical string and not the statement ATTACH...????
Don understand the strategy...

[HansV]

Could you explain in more detail what you mean, and perhaps post a link to the revelant website?

[HansV]

Please edit your post and change the URL to a clickable link.

[sal21]

http://bytes.com/groups/asp/756264-adodb-c...tion-sqlexpress

Note:
For future i want to use the connection in asp page...

[HansV]

I can't find information about an Attach statement. I think you'll have to create an ADODB.Connection object with a connection string like

ConnectionString = "Provider = SQLNCLI;" & _
"Data Source = .SQLEXPRESS;" & _
"Initial Catalog = <db name>;" & _
"User ID = <username>;" & _
"Password = <password>;"

substituting the correct names for the database, username and password.

[sal21]

ok tks for the good info...
but the "dot" before SQLEXPRESS... i msut substityuite whit the or name of client where is installed the instance similar 178.254.36.148 SQLEXPRESS?
In the string you have posted have a dubt about how to the vb code find the instance in my lan...

[HansV]

It's worth a try. I cannot help you with that, I don't use SQL Server Express or ASP.

[sal21]

no prob, tks in other case.