ADODB.Connectio n - from ACCESS to Oracle

[Marcin Wasilewski]

Hi, I know that there were a lot of common posts but I stel have a
problem.

I'm using this code:

set x = new adobd.connectio n

x.open "provider.sqlol edb;" & _
"data source = server.name.com ;" & _
"port = 1234;" & _
"user id = name;" & _
"password = passwd;"

and I have this error:
"Invalid connection string attribute".

I'm starting to bet know adodb so please for your understanding.
Have you any idea what is wrong.

Thank you very much.

Marcin

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try:

x.open "provider=sqlol edb;" & _
"data source=server.n ame.com;" & _
"port=1234; " & _
"inital catalog=MyDatab ase;" & _
"user id=name;" & _
"password=passw d;"

You'd left out the inital catalog. Substitute the name of your database
for "MyDatabase ."

If the target server is set up as a normal SQL Server installation, then
you don't need the port parameter, 'cuz it will default to the SQL
Server port.

If you know the IP address of the server, you may want to try that
instead of "server.name.co m;." I'm not sure if the DNS will translate
the domain name to the IP address when it is in a connection string.
But I may be wrong....

--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQ9qCHIechKq OuFEgEQJzSQCg2b nlu9zILCMa2IpqQ 1UyHOe1ipkAoLAm
njo11d35lC8Ffuy neW+UcRnB
=sWAe
-----END PGP SIGNATURE-----
Marcin Wasilewski wrote:

Hi, I know that there were a lot of common posts but I stel have a
problem.

I'm using this code:

set x = new adobd.connectio n

x.open "provider.sqlol edb;" & _
"data source = server.name.com ;" & _
"port = 1234;" & _
"user id = name;" & _
"password = passwd;"

and I have this error:
"Invalid connection string attribute".

I'm starting to bet know adodb so please for your understanding.
Have you any idea what is wrong.