DSN-less OBDC connections

[#1]

Hi,

I'd like to connect to an ODBC database without defining an DSN-Datasource. Is it possible to declare all configuration items in the "ODBC CONNECT TO" statement?

This example don't work:

ODBC CONNECT TO "Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=myDataBase; User=myUsername;Password=myPassword;Option=3"

[biester · Accepted solution]

See reference manual p. 292, where it says: "datasourcename must be a defined ODBC data source." So from my point of view the answer to your question is a quite clear "No" (or the manual is misleading).

Rgds,
Joachim

[#3]

I found the solution using the "Microsoft OLE DB Provider for ODBC Drivers". You can put the DSN-less ODBC connection string in the "Extended Properties" tag.

Here the example for MySQL:

CONNECT TO [Provider=MSDASQL.1;Persist Security Info=False;Extended Properties="DRIVER={MySQL ODBC 5.1 Driver};
UID=remyUserID;Server=myServerName;Database=myDB;Password=myPassword;OPTION=3;PORT=3306;"];

that works perfectly.

Bye,
Reiner

[#4]

Using CONNECT TO instead of ODBC CONNECT TO is working.

CONNECT TO [DRIVER=SQL Server Native Client 10.0;UID=XXX;DATABASE=XXX;SERVER=XXX] (XUserId is XXX, XPassword is XXX);

[Anonymous]

Hi,

is DSN-less connection is really working for you people.

If it is working , can you please give a sample script for DSN-less on ORACLE .

Thanks