[freetds] Res: How to make a connection without freetds.conf
Alexandre Gazola
alexandregazola at yahoo.com.br
Mon Jul 16 17:15:04 EDT 2007
Hello,
I I´m not using SQLDriverConnect to make my connection....
I´m doing the connection with FreeTDS using the function ct_connect (see the simple code bellow).
The "host" parameter used to make the connection matches a section in the freetds.conf file, as specified. Is there how to modify the code bellow so that the freetds.conf file is not needed?
thank you
bool
TeFreeTDS::connect (const string& host, const string& user, const string& password, const string& database, int port)
{
CS_RETCODE ret;
char query[30];
errorMessage_ = "";
close();
ret = ct_con_alloc(ctx_, &conn_);
if (ret != CS_SUCCEED)
{
errorMessage_ = "Connect Alloc failed!";
return false;
}
ret = ct_con_props(conn_, CS_SET, CS_USERNAME, (char *) user.c_str(), CS_NULLTERM, NULL);
if (ret != CS_SUCCEED)
{
errorMessage_ = "ct_con_props() SET USERNAME failed!";
return false;
}
ret = ct_con_props(conn_, CS_SET, CS_PASSWORD, (char *) password.c_str(), CS_NULLTERM, NULL);
if (ret != CS_SUCCEED)
{
errorMessage_ = "ct_con_props() SET PASSWORD failed!";
return false;
}
ret = ct_connect(conn_, (char *) host.c_str(), CS_NULLTERM);
if (ret != CS_SUCCEED)
{
errorMessage_ = "Connection failed!";
return false;
}
strcpy(query, "use ");
strncat(query, (char *) database.c_str(), 20);
if (!execute(query))
return false;
isConnected_ = true;
host_ = host;
user_ = user;
password_ = password;
database_ = database;
return true;
}
----- Mensagem original ----
De: James K. Lowden <jklowden at freetds.org>
Para: FreeTDS Development Group <freetds at lists.ibiblio.org>
Enviadas: Sexta-feira, 13 de Julho de 2007 17:08:52
Assunto: Re: [freetds] How to make a connection without freetds.conf
Alexandre Gazola wrote:
> I checked the DNS-less section of the user guide on the site, and
> changed my connection string to the following:
>
> "DRIVER=FreeTDS;SERVER=forte;UID=teste;PWD=teste;DATABASE=GAZOLA_UNBA_R
> ;TDS_Version=7.0;Port=1695;"
>
> but that DIDN'T WORK.
1. Make sure you're using SQLDriverConnect.
2. Try export TDSDUMP=stdout and see if it's connecting to your host
correctly. The log will show your server hostname and port (and probably
the TDS version). If those are right, it's an authentication issue.
--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS at lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
Flickr agora em português. Você cria, todo mundo vê.
http://www.flickr.com.br/
More information about the FreeTDS
mailing list