VBScript and mySQL

[Jeremy Arntz]

Hello,

I am having trouble connecting to a mySQL server through VB Script via myODBC...
When I used to use Access I used this script to connect:

  Qt = Chr(34)
  Set caldb = Server.CreateObject("ADODB.Connection")
  caldb.Open "caldb" 

Which returned an error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[TCX][MyODBC]Access denied for user: 'jarntz@MORPHEUS' (Using password: YES)
  
I tried:
  Qt = Chr(34)
  Set caldb = Server.CreateObject("ADODB.Connection")
  caldb.Open "Driver=MySQL;Server=;DB=cal;UID=jarntz;PWD=thematrix;OPTION=16386;" 

which works, but I don't know if it is an acceptable way of doing things...

Any Suggestions... I apologize I am new to mySQL... hence my issue.

Jeremy