Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2002
    Posts
    3

    Angry Unanswered: 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

    Stefan

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    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.

  3. #3
    Join Date
    Aug 2002
    Posts
    3

    Talking Got it

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •