MySQL Connection String Info

Monie · #1 (**permalink**) Oct 19th, 2007, 07:28

I have been using MySQL since few weeks ago and I got this connection string from somewhere but I could not understand the OPTION thing.

Could somebody give a brief info about this?

and one more thing, is there any LockType (like in MS Access MS SQL) in MySQL?

Thanks..

Code: Select all

connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root; PASSWORD=mypassword;"

Monie · #2 (**permalink**) Oct 22nd, 2007, 09:14

Any one? Please

c010depunkk · #3 (**permalink**) Oct 22nd, 2007, 10:50

I've worked with SQL / Access for over two years now and I still don't understand the connection strings....

Maybe you can find some answers here: http://connectionstrings.com/

Monie · #4 (**permalink**) Oct 23rd, 2007, 04:16

Quote:

Originally Posted by c010depunkk

I've worked with SQL / Access for over two years now and I still don't understand the connection strings....

Maybe you can find some answers here: http://connectionstrings.com/

LOL...
That's where I learn all the connection string that I use in my page.

but, they don't include enough explanation to the connection string, like the "OPTION=4" sometimes I saw "OPTION=3", I don't understand that and I don't know if I should know that either. Maybe it is some kind of "LOCKTYPE"??

Thanks..

c010depunkk · #5 (**permalink**) Oct 23rd, 2007, 06:41

MySql official documentation:
http://dev.mysql.com/doc/refman/5.0/...nnectionstring

Monie · #6 (**permalink**) Oct 23rd, 2007, 06:54

I am using MySQL v5.0.
Does your link apply to my connection string, that looks different.

Code: Select all

connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=mydatabase; OPTION=4; UID=root; PASSWORD=mypassword;"

Monie · #7 (**permalink**) Oct 23rd, 2007, 06:57

I have this two kind of connection string that I always use:

Connection 1

Code: Select all

Dim connectionString,rs
connectionString= "DRIVER={MySQL ODBC 3.51 Driver}; SERVER = localhost; DATABASE=monieweb; OPTION=3; UID=root; PASSWORD=monie;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM userlogin", connectionString, 1, 3

Connection 2

Code: Select all

Dim connectionString, conn, rs
connectionString = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=localhost; DATABASE=monieweb; OPTION=3 UID=root; PASSWORD=monie;"
conn.Open(connectionString)
Set rs = conn.Execute("SELECT * FROM userlogin")

and I have rs.AddNew in my code to add new record to the database.

Code: Select all

rs.AddNew 
'Put username and password in record
rs("username")=Username
rs("password")=Password
rs("fullname")=Fullname
'Save record
rs.Update

The first connection will do just fine, but the second one, I got this error message:

Code: Select all

Error Type:
ADODB.Recordset (0x800A0CB3)
 Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/create.asp, line 42

c010depunkk · #8 (**permalink**) Oct 23rd, 2007, 09:21

Well, I'm no guru, so I can't really help you further. Till now I was just applying common sense and Google on your problem

good luck....

dab42pat · #9 (**permalink**) Oct 23rd, 2007, 09:52

I have no idea what I am talking about here so please ignore me if you want but after a bit of googling I found this solution. In between connection 1 and connection 2 there should be an rs.close

Monie · #10 (**permalink**) Oct 24th, 2007, 01:48

Quote:

Originally Posted by dab42pat

I have no idea what I am talking about here so please ignore me if you want but after a bit of googling I found this solution. In between connection 1 and connection 2 there should be an rs.close

lol..

The connection will not be at the same page.
I use either one of them.

I want to perform rs.AddNew and rs.Update in my page.
It can be done only by using Connection 1.

When I use Connection 2 I get the error message.
Thanks..

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] Connection string for password protected databases	alexgeek	Classic ASP	6	Oct 31st, 2007 15:59
PHP n MySQL connection	uddin	PHP Forum	1	Apr 18th, 2007 06:41
another database connection question! asp and mysql	fogofogo	Classic ASP	4	Dec 2nd, 2005 08:48
Connection String DSN-less	gwx03	Classic ASP	11	Nov 26th, 2003 12:07
dns less connection String	djaccess	Classic ASP	7	Oct 5th, 2003 14:34

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
MySQL Connection String Info