Don_S
|
| Posted: 05/04/2005, 10:36 AM |
|
I am tying to connect to my Access db on my website and am having no luck  My host gave me the following string to use as my connection but i am not sure how to use it.
Any help would be great.
Don
Set oConn=Server.CreateObject("ADODB.Connection")
dbpath = Server.MapPath(Your Access DB File)
PWD = "Your Password"
ConnString = "Provider=MSDASQL;" & _
"DRIVER={Microsoft Access Driver (*.mdb)};"& _
"DBQ=" & dbpath & ";" & _
"password=" & PWD & ";"
oConn.Open(ConnString)
|
|
|
 |
Nicole
Posts: 586
|
| Posted: 05/05/2005, 4:32 AM |
|
Don,
You can include real path, database name, password into connection string and put it into database Connection dialog - > Use Connection String option.
_________________
Regards,
Nicole |
 |
|
peterr
Posts: 5971
|
| Posted: 05/05/2005, 12:56 PM |
|
Based on the ConnString that you provided above, you should enter such Connection String in CCS:
Provider=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=Server.MapPath(Your Access DB File);
You will only need to replace "Your Access DB File" with the .mdb filename. I'm assuming that you don't need a password.
Please also see: http://support.yessoftware.com/kb_article.asp?article_id=54
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
sagar
|
| Posted: 05/20/2005, 1:52 AM |
|
Plz send me complete code for accessing the table from mysql database from java programming with DSNless connection.
Regard's
SAGAR
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/20/2005, 9:32 AM |
|
JDBC Driver: org.gjt.mm.mysql.Driver
Database URL: jdbc:mysql://localhost/...
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
