Please inform me how do I connect a myserv database on server ?

What is syntax ?

If dsn is vikas then what will be the syntax ?

With regards
Vikas AThavale

Vikas Athavale
http://www.lic-india.com
Mobile 91 9821461975

Set con = Server.CreateObject("ADODB.Connection");
strCon = "dsn=vikas"



:: soulcreation.com ::

Hey guys..I am kinda new to this ASP Stuff, and can't figure out the solution to an error that I am getting..Here's the error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/shivani/cosmicswap/Clssfd.asp, line 6


And here's the code that I have on line 6 on this clssfd.asp page:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open"DRIVER= {Microsoft Access Driver(*.mdb)};DBQ=URL=fpdb/CosmicSwap.mdb"


Could anyone help me
Email me or post your answer here.

shivani




shivani

It should be:

DBQ=" & Server.Mappath("/fpdb/ComsmicSwap.mdb")

(assuming that the fpdb directory is off the root of your website. The Server.Mappath() function returns the physical path of the supplied virtual path.