ADODB.Connection - 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.connection

x.open "provider.sqloledb;" & _
"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=sqloledb;" & _
"data source=server.name.com;" & _
"port=1234;" & _
"inital catalog=MyDatabase;" & _
"user id=name;" & _
"password=passwd;"

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.com;." 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:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQ9qCHIechKqOuFEgEQJzSQCg2bnlu9zILCMa2IpqQ1UyHO e1ipkAoLAm
njo11d35lC8FfuyneW+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.connection

x.open "provider.sqloledb;" & _
"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.