MyODBC VB6 Problem

[dpk136]

I have made a program that runs off the task scheduler. It connects to a web database using MyODBC. This works most of the time, but once in a while i'll get the MyODBC DSN connection window. I'm not sure why this pops up. should i upgrade the MyODBC from version 2.5 to the newest version? If this is not the case, is there a way to hide this in code or through settings.



David Kuhn
------------------

http://www.davidpkuhn.com

 

[QatQat]

Sounds like a password authentication problem; you must pass your DSn connection authentication in VB as well and not only in the DSN connection window.

assuming you use ADO

myConn.open "myDSNName", "myUsername", "myPassword"

Cheers

QatQat


Life is what happens when you are making other plans.

 

[dpk136]

I have both of these set...in the dsn and the connection. still doesn't work right all the time.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[QatQat]

have you tried to use myOLEDB instead? YOu should also get improved connections.

A connection string sample is at

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMySQL

Cheers

QatQat

Life is what happens when you are making other plans.

 

[dpk136]

I'll try this and let you know...thanks for the help.

David Kuhn
------------------

http://www.davidpkuhn.com

 

[dpk136]

Where do i get the OLEDB from

David Kuhn
------------------

http://www.davidpkuhn.com

 

[QatQat]

http://sourceforge.net/projects/myoledb/

Cheers

QatQat

Life is what happens when you are making other plans.