Skip to Content.
Sympa Menu

freetds - Re: [freetds] Problem connecting to SQL server on linux

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Frederik Teerlinck" <largowww AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Problem connecting to SQL server on linux
  • Date: Mon, 25 Sep 2006 12:32:03 -0700

Of course I did. I'm not that new with this stuff ;-) It's just that I'm
used
to working with mySQL databases and this is the first time I need to connect

to an SQL server using odbc. I'm guessing that it has something to do with
the setup of my odbc driver.

Isn't there a way to get more information back then just 'SQL_ERROR'?


2006/9/25, Jeff Dahl <jddahl AT micron.com>:

Frederik Teerlinck wrote:
> ret = SQLDriverConnect(connection, NULL, (SQLCHAR *)
> "DRIVER=FreeTDS;Address=<IPaddress of the SQL
> server>;UID=<login>;PWD=<pwd>;DATABASE=<DBname>;port=<port>;", SQL_NTS,
> outConnectionString, 1024, &len, SQL_DRIVER_NOPROMPT);
> ....
>
Did you replace <IPaddress of the SQL server>, <login>, <pwd>, <DBname>,
and <port> with the correct values
(i.e."DRIVER=FreeTDS;Address=my.servers.ip.address
;UID=myLogin;PWD=myPassword;DATABASE=myDatabaseName;port=myDatabasePort;"
)?
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds





Archive powered by MHonArc 2.6.24.

Top of Page