SQL Toolkit - UserID/Password on Access Database?

[KHolland]

I recently installed the SQL toolkit for LW/CVI and I'm having some difficulty logging into a database with a user ID and password. I've read around on the board and tried some of the recommendations of others but still can't get the DB to initialize.

I've tried the following varations on syntax:
DBhandle = DBConnect ("DSN=DB;USER=uid;PASSWORD=pw");
DBhandle = DBConnect ("DSN=DB,USER=uid,PASSWORD=pw");
DBhandle = DBConnect ("DSN=DB;UID=uid;PW=pw");
DBhandle = DBConnect ("DSN=DB,UID=uid,PW=pw");
DBhandle = DBConnect ("DSN=DB,UID=uid\00,PW=pw\00");
DBhandle = DBConnect ("DSN=DB;UID=uid\00;PW=pw\00");

I have also set up the user ID and password for the ODBC settings under the control panel and still - nothing. Any
one have any recommendations??? I have tried creating a new database with no password and I can access it so I'm assuming either the uid/pw I have been provided is incorrect, or my syntax is wrong. I'm leaning toward the syntax as being the problem.

Thanks again guys!

[RobertoBozzolo]

Looking at thw DBConnect function help, I see that either you can use the 'User ID' and 'Password' parameters or you can use 'UID' and 'PWD' parameters. The second option is not recognized from all drivers.

In my experience, ODBC drivers are quite snob, and the correct syntax of the keywords is relevant to them, so I suggest you to check and correct the spelling of the keywords in your command.

Hope I gave you a little help...
Roberto

[davidx]

Dit you find a solution ???

Would like to do the same...

thanks a lot!

[JJHGH]

hello,I need this project,is it possible to give

[Dennis_Knutson]

You've set a record for the number of hijacked threads and for resurrecting one of the oldest.

[mmeinders]

I have the same problem. Nothing seems to work. I would assume the following syntax is correct:

myConn = DBConnect ("Provider=SEQUEL ViewPoint;User ID=JohnDoe;Password=abcd;");

But I get Error -10

It works without the UID/PW part.

Surely someone has figured out how to do this? 🙂

[rolfk]

If you look in the 2nd post, it says something about using the "UID" and "PWD" keywords, not "User ID" and "Password".  But these keywords are database driver specific so you would have to check your database driver documentation for the exact syntax. But it is very unlikely that "User ID" is a correct keyword, since it contains a space.

Assuming that your Provider Name "Sequel" refers to a Sybase database driver, the correct connection string would be something like "DataSource=myASEserver;Port=5000;Database=myDataBase;Uid=myUsername;Pwd=myPassword;"

Looking for Sequel Viewpoint the syntax seems to be

:user=>'...', :password=>'...'

for this weird driver, but the only examples I can find online seem to be for some sort of scripting language (supposedly Ruby) so this syntax may be Ruby specific.

[vix]

A good place to look for connection strings is https://www.connectionstrings.com/.

I found it really useful so many times

[mmeinders]

Thanks, I am still checking 🙂