Sunday, March 25, 2012

Connection problem

Hello!
Recently i have found SQLAPI++ library and it convinced me.
BUT i have some problems to connect to the SQL Server.
My connection string looks like that:
con.Connect(
"MOON", // database name
"abc", // user name
"abc", // password
SA_SQLServer_Client);

I always receive this message trying to connect:
[DBNETLIB][ConnectionOpen
(Connect()).]SQL Server does not exist or access denied

or with this connectioj string

con.Connect(
"MOON@.myClient", // database name
"abc", // user name
"abc", // password
SA_SQLServer_Client);

my authication seems to be wrong!

Is that a sql server configuration problem? I use windows authication to connect to the database server.

Any hints are welcome

Thanks

StefanWhat language are you using to program ? The authentification method could be your problem. Have you tried to enable sql server authetification and adding the userid abc and password abc ? Also, check out the connection method parameters - there should be a parameter that allows you to choose authentification method.|||Originally posted by rnealejr
What language are you using to program ? The authentification method could be your problem. Have you tried to enable sql server authetification and adding the userid abc and password abc ? Also, check out the connection method parameters - there should be a parameter that allows you to choose authentification method.

I use C++ with the SQLAPI++ Library!
I found out how it does it work. The userID and the password string have to be empty! Too easy
Thanks
Stefan

No comments:

Post a Comment