[VB] DSNless connection to oracle

[saprouzy]

"Provider = MSDAORA;User ID=myuser;Password=mypwd;Data Source=myserver;DATABASE=mydb;"

hey there,

am using this DSNless conenction string to connect to an oracle db

is there a way to set the server name instead of the service name

(ie: oracle.world) in the Date Source field.

thanks.

[DavidNL]

I don't have any experience with oracle, but you might find your answer here:

http://www.connectionstrings.com/

[alrichey]

Hello as far as I am aware you can not specify it that way.

Hope that helps!