Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Connecting to MySQL using 'Dim Connect'		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

SubKamran
Junior Member

101 Posts
Posted - 27 April 2002 :  14:19:30  Show Profile  Visit SubKamran's Homepage  Send SubKamran an AOL message  Send SubKamran a Yahoo! Message
What's the ASP code for connecting to MySQL using Dim Connect?

I've done it wit Access and SQL...

Is it:

Dim Connect
Set Connect = Server.CreateObject("ADODB.Connection")

???

Kamran A
14/m/mn
Minneapolis, MN
Web Dev/Flash Dev

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 27 April 2002 :  16:26:03  Show Profile
There is no different way in creating the ADODB.Connection object, between the databases.

We use that for the Snitz Forums. Only the connection string for each database is different.

«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists !
Go to Top of Page

SubKamran
Junior Member

101 Posts
Posted - 27 April 2002 :  20:23:00  Show Profile  Visit SubKamran's Homepage  Send SubKamran an AOL message  Send SubKamran a Yahoo! Message
yah, i know! but what's the connection string?

Connect = ???

Kamran A
14/m/mn
Minneapolis, MN
Web Dev/Flash Dev
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 27 April 2002 :  21:41:34  Show Profile
Why don't you look in your config.asp file?
strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL


«------------------------------------------------------»
Want to know when the next version comes out,
as soon as possible? Join our Mailing Lists !
Go to Top of Page

SubKamran
Junior Member

101 Posts
Posted - 28 April 2002 :  17:01:56  Show Profile  Visit SubKamran's Homepage  Send SubKamran an AOL message  Send SubKamran a Yahoo! Message
yah, nevermind, i figured it out...now i g2 eait until my host gets up...thx dav

Kamran A
14/m/mn
Minneapolis, MN
Web Dev/Flash Dev
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.19 seconds. Powered By: Snitz Forums 2000 Version 3.4.07