Subject | Connection string for XTG Systems InterBase6 ODBC Driver |
---|---|
Author | David A. Frischknecht |
Post date | 2003-01-04T20:54:14Z |
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
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