Connection string for sql 08

[crackon]

Hi

Just moving to sql 08 and I'm in SSMS - if this is my connection string from my site what do I replace it with to connect to converted SQL dbs?

on error resume next

set connTemp=server.createobject("adodb.connection")

'connString = "DSN=cq"
connstring = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" &server.MapPath("db/cq.mdb")&";"

connTemp.Open ConnString

 

[gmmastros]

check here:

http://connectionstrings.com

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[markros]

In addition to George's advice see Tatworth's suggestion in this thread

http://mail.google.com/mail/#search/udl/1220b623f64e87f3

about creating x.UDL and double clicking on it.

 

[markros]

Oops, sorry, meant here

http://forums.asp.net/p/1438237/3253301.aspx#3253301

 

[crackon]

What if I need to connect to a hosted server, we have a site, we upload, where is my dbo to upload>?