asp_database_setup thread: ASP & MySQL connection ?
Message #1 by "kristof vercruyssen" <kristof.vercruyssen@p...> on Tue, 22 May 2001 16:16:51
|
|
hi
is this possible (see subject).
If yes, how can i make the connection. I've worked with an Access-DB, but
i'd like to make a board, and with an Access-DB, this is almost impossible.
thanks for your help in advance
Kristof
Message #2 by walter@w... on Wed, 23 May 2001 09:56:41
|
|
This is possible with a DSN
Then connect like this
Set conn = server.createobject("ADODB.connection")
Conn.Open "DSN=yourdns;SERVER=yourlinixserver.com;DATABASE=yourdb;USR=youru
sername;PWD=yourpassword"
Message #3 by "Sonya Leopard" <skylounge@i...> on Tue, 29 May 2001 06:13:47
|
|
Please give me more details on how I can connect ASP and MySql. I don't
have either Office 2000 nor SQL Server, but I have MySql and Tomcat.
> This is possible with a DSN
>
> Then connect like this
>
> Set conn = server.createobject("ADODB.connection")
>
Conn.Open "DSN=yourdns;SERVER=yourlinixserver.com;DATABASE=yourdb;USR=youru
Message #4 by "Sonya Leopard" <skylounge@i...> on Tue, 29 May 2001 06:06:58
|
|
> This is possible with a DSN
>
> Then connect like this
>
> Set conn = server.createobject("ADODB.connection")
>
Conn.Open "DSN=yourdns;SERVER=yourlinixserver.com;DATABASE=yourdb;USR=youru
Message #5 by walter@w... on Tue, 29 May 2001 08:11:17
|
|
Tell me what is your platform?
If you running windows then make a ODBC connection
Message #6 by "Sonya Leopard" <skylounge@i...> on Wed, 30 May 2001 22:41:29
|
|
> Tell me what is your platform?
>
My platform is Windows 2000. How I can connect ASP & MySQL & ODBC or
MyODBC?
I also would like to know how I can set my DSN.
Many thanks. Sonya
|