I can connect to my FTP site with UltraDev, but cannot access an .mdb.

If my site is www.xyz.com, and my database is myDB.mdb, my UserID is UUUID, my password is PWPWRD, and the mdb is stored in directory "database", what is a valid connection string???

Please help, I'm cracking up.

there's a great article on connection strings at
www.basic-ultradev.com/articles/ADOConnections/

I personally would suggest using the OLEDB string as opposed to the ODBC (it's faster)... that's further down on that article.

Joel Martinez [ ]
----------
E-Commerce Concepts with Ultradev...pre-order yours at
www.basic-ultradev.com/ecomm_concepts/

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I can connect to my FTP site with UltraDev, but cannot access an .mdb.

If my site is www.xyz.com, and my database is myDB.mdb, my UserID is UUUID, my password is PWPWRD, and the mdb is stored in directory "database", what is a valid connection string???

Please help, I'm cracking up.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

1]
This connection string works for me on my site:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source= E:\websites\www.psigroup.co.uk\fpdb\compasstravel.mdb;"

2]
Upload this script as a .asp file in your database folder to find your directory path, to your database.

&lt;html&gt;

&lt;head&gt;
&lt;title&gt;Where Am I&lt;/title&gt;
&lt;/head&gt;

&lt;body&gt;

&lt;p&gt;Path Translated: &lt;b&gt;&lt;%= Request.ServerVariables("PATH_TRANSLATED" %&gt;&lt;/b&gt;&lt;/p&gt;

&lt;/body&gt;
&lt;/html&gt;

3]
Make sure your ISP has set the database directory up with the correct permissions

love Adele
x