PDA

View Full Version : Where can I find instructions on odbc ConnectionStrings?



rainspider
13th November 2009, 04:56
Windows + qt 4.6.0 for opensource+ nmake

when i using ADO connection string, field.
eg:

Provider=SQLOLEDB.1;User ID=sa;Password=123456;Initial Catalog=NorthWind;Data Source=127.0.0.1
But use this connectionstring (come form qt help document),successful .
eg:

DRIVER={SQL Server};SERVER=127.0.0.1;UID=sa;PWD=12345;DATABASE =NorthWind

code:

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("connectionstring");

Who can tell me the difference between them ,or Where can i find the instructions on the connectionstrings?

Chisum
13th November 2009, 17:25
The purpose of this reply is to provide some answers to the question regarding "Where can i find the instructions on the connectionstrings?" contained in your posts.

First, check the topic on Google. There are a bunch of links to information on connection strings.

Second, this site seems to contain a lot of information:

http://www.connectionstrings.com/

And finally, explore some of the other links. There is a lot of information available on the Web regarding connection strings.

Gary