Re: DSN-less connection for Informix database
- From: "Bill Nguyen" <billn_nospam@xxxxxxxx>
- Date: Mon, 23 Apr 2007 20:10:08 -0700
Jeff;
Where do you go to get this info in the registry?
Are you talking about ODBC for Informix database?
Thanks
Bill
"jeff" <jhersey at allnorth dottt com> wrote in message news:OkT5vkahHHA.4296@xxxxxxxxxxxxxxxxxxxxxxx
To create dsn'less ODBC connections, I create a DSN on my machine and look at the registry to see what data elements it creates, I then simply create a connection string. FOr example, here is on I use to connect Timberline Software - P/O system.
Driver={Pervasive ODBC Client Interface}; ServerDSN=purchasingdata; ServerName=10.10.10.7.1583; TCPPort=1583; TransportHint=TCP:SPX
I then add all the other connection data to it - user name, password and so on. This string above replaces the need for me to create a DSN connection profile on each client machine or on the citrix server.
Jeff.
"Bill Nguyen" <billn_nospam_please@xxxxxxxx> wrote in message news:eT0MI24gHHA.1240@xxxxxxxxxxxxxxxxxxxxxxxI have this connection string using ODBC DSN
Dim FactorJaco As String = "dsn=jaco;catalog=factor;uid=user;pwd=passord"
This requires an ODBC DSN (jaco) at every client PC. I need to use DSN-less connection for terminal server setup.
Any help is greatly appreciated.
Bill
.
- Follow-Ups:
- References:
- DSN-less connection for Informix database
- From: Bill Nguyen
- Re: DSN-less connection for Informix database
- From: jeff
- DSN-less connection for Informix database
- Prev by Date: Re: provider cannot be found
- Next by Date: parameterized query from code
- Previous by thread: Re: DSN-less connection for Informix database
- Next by thread: Re: DSN-less connection for Informix database
- Index(es):
Relevant Pages
|
