Re: Trouble connecting DBGrid and ADODataSet


Thanks guys. That worked. I could have sworn I tried that...

My problem now is that I'm being prompted for the user name and password on the ADOConnection.Open. I specify the user name and password in the connection string and I don't want the user to be prompted for it.

Here is my connection string:

sConnection := 'Provider=MSDASQL.1;Password = ' + sPassword +
';Persist Security Info=True;' +
'User ID=' + sUserName + ';' +
'Extended Properties=DRIVER={Oracle ODBC Driver for Rdb};' +
'SERVER=' + sVax_Server + '@' + sVax_Class + '@W;UID=' +
sUserName + ';' + 'PWD =' + sPassword + ';' +
'SVR=' + sVax_Server + ';CLS=' + sVax_Class + ';XPT=2;CSO=1;DBA=W;DSO=0;TLL=;TLO=0;';

the variables are all set correctly as follows:

sPassword := 'testpassword';
sUserName := 'ivf_pgm1';
sVax_Class := 'Vax_user_p';
sVax_Server := 'our.server.com';


Thanks for any help, Alan
.

Relevant Pages