Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

DSN-less OBDC connections

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"


1 Solution

Accepted Solutions
biester
Specialist
Specialist

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

View solution in original post

4 Replies
biester
Specialist
Specialist

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

View solution in original post

Not applicable
Author

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

Not applicable
Author

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);

kumar_qlik
Contributor
Contributor

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