I have everything working fine. I managed to install myODBC, even imported
mySQL databases into MS Access and play around. I managed to use it with
Macro. UltraDEV. But my pages have to be *.ASP.

Now I would like to upload the CODE to the remote server on UNIX that supports
ASP via ChilliSoft and in my /Connection folder I have the testing.asp (connection name)

THE PROBLEM IS:
I was connecting to local but now I have to re-connect it to the
mySQL Server or to the ChilliSoft server. I also have a connection there connecting
to mysql.

I get this:

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

ADODB.Recordset.1 error '80004005'

SQLState: S1000
Native Error Code: 1045
[TCX][MyODBC]Access denied for user: 'etc@[url]http://www.mydomain.com[/url]' (Using password: YES)


/directory/index.asp, line 5

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

The /Connection/etc.asp &lt;--- Connection file or the include is:

I removed the 1st and last character before / after the % because it would not display correctly here.


<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
%
// FileName="Connection_odbc_conn_dsn.htm"
// Type="ADO"
// HTTP="false"
// Catalog=""
// Schema=""
var MM_test_STRING = "dsn=etc;uid=xxxx;pwd=xxxx;"
%

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

Should the above be a string to connect to mySQL or the ChilliSoft ASP sort
of like ODBC.

Under ChilliSoft I have DSN:

Data Source Names

Name Driver
etc MySQL 3.22.32-1

--------------------

Data Source Name: etc

Server: www.mydomain.com &lt;--- I might have to change this to the actual IP address.
in myODBC I am connecting via IP I am not sure... but that should be the issue.

Database: thename

username: @#$@@#
passcode: @#@@$@$@

-----------------------

Do I need to edit the /Connections/etc.asp and add some sort of PHP connection string? in order for my ASP pages to actually connect to the database and all the code designed on my Win machine to work. I know while I was designing it locally I was using myODBC DSN Locally and that was connecting to the mySQL database.

I hope this makes sense...

Thanks for any input or help on this. <b>This is my only issue I've got on Windows VS Linux</b>. If this goes well than I am keeping my RAQ.