ODBC Connection

[Lam]

hi
I create a System DSN which connect to the Pervasive database located on
a computer in the network. How can I write the code to connect to the
database
by using that system DSN?

Thanks a lot

 

[NuB]

DSN="myDataBase";

 

[Carlos J. Quintero [.NET MVP]]

Yes, you must use the ODBC .NET Provider an a proper connection string, such
as DSN=mySystemDSN. Also you could avoid messing with DSNs and use a
DSN-less connection (search the concept in google) such as
"Driver={MyODBCDriver}; blah, blah""

--
Best regards,

Carlos J. Quintero

MZ-Tools: Productivity add-ins for Visual Studio .NET, VB6, VB5 and VBA
You can code, design and document much faster.
Free resources for add-in developers:
http://www.mztools.com