problem with odbcconf

Question

problem with odbcconf

jarkkoniem

Valued Member

Points: 66
More actions
January 9, 2008 at 5:49 am

#127495

I am trying to create a odbc data source with following command:
ODBCCONF /A {CONFIGDSN "SQL Server" "DSN=test3 | SERVER=.\SQLEXPRESS | Trusted_Connection=Yes |Database=measurements"}
This creates the data source but if I try it the connection to the database fails.
The strange thing is that if I create an Identical data source using the graphical obdc data sources tool the data source created this way works fine.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

jarkkoniem Valued Member Points: 66 More actions · Answer 1

I'll change my question a bit. What string I need to the place of "sql server" if I want to use sql native client driver. Simply "sql native client driver" did not work.

Tom Garth SSCertifiable Points: 6193 More actions · Answer 2

OLE DB uses SQLNCLI.1.

Tom

Tom Garth
Vertical Solutions[/url]

"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers

ivy-alice Grasshopper Points: 23 More actions · Answer 3

Hello everybody

Thank a lot for the example of ODBCCONF line.

I just have a little question, (cause when i create an existing ODBC connexion, sometimes, the old one is replaced by the new one, sometimes, I have 2 connections with the same name )

I'm asking to myself if ODBCCONF allow to destroy an existing connexion, and how ?

Thank for any help

Ivy