My Oracle 73 has a different syntac for the server:
sqlstringconnect('Driver=Oracle73;UID=myid;PWD=mypwd;
DBQ=reg6;')
I am not sure when this change took place. I am connecting to an Oracle 8 database. I do not know if this makes a difference.
As for getting a login form, I am not sure how to prevent that. I have never had that problem. There is a SQLSetProp() that will turn off the DispLogin, but it requires a connection handle which you can get until you establish a connection. This is a really dumb property for this type of connection creation.
Now, under the menu Tools/Options, you can change the Display Login to Never or Only When Necessary. Putting SQLDispLogin=1 in the Config.FPW had no effect on changing the default setting of this when I launched VFP.
>On this same topic, in the code below I still get the Oracle authentication box even though I I have the correct username/password. How to I get rid of this? It will ultimately in a COM object and I can't have any interactivity. Thanks.
>
>
> store sqlstringconnect('Driver=Oracle73 Ver 2.5;UID=guest;PWD=password;CONNECTSTRING=qip.world;') ;
> to nHandleResult
>
> if nHandleResult < 0
> cNothin = messagebox('Cannot make connection', 16, 'SQL Connect Error')
> else
> cNothin = messagebox('Connection made', 48, 'SQL Connect Message')
> = sqldisconnect(nHandleResult)
> endif
>
>
>
Mark McCasland
Midlothian, TX USA