Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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


  Return to Index