Subject Connection string for XTG Systems InterBase6 ODBC Driver
Author David A. Frischknecht
Hello,

I had asked this question before, but the answer I received didn't work for
me. I'd like to know how to construct a connection string to the driver
listed in the subject of this message. I'm using VB 6 Ent. Edition and I'm
using ADO to manipulate the database. I'm currently using a MySQL, but the
people I work for want me to switch over to Firebird. I've gotten all the
data migrated correctly, but I'd like to be able to connect to the database
w.out using a DSN. Much thanks for any and all input. By the way, I've
included the string I'm already using.

strCxn = "Driver=MySQL;Server=" & ServName & ";Port=" & ServPort &
";Option=0;Stmt=;Database=consign;Uid=root;"

David A. Frischknecht
http://fishnetonline.tripod.com