Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle 7.3 use connect string instead of DSN
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00320491
Message ID:
00362262
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform