asked on 7/20/2008

excel 2003 vba to sql server 2005 express

hello to the expert,
I'm trying to connect to sql server 2005 express with excel 2003 vba using this connection
strConn = "PROVIDER=SQLOLEDB;"
strConn = strConn & "DATA SOURCE=(local);" ' the sever on my LepTop
strConn = strConn & "Initial Catalog=test;" ' my database
strConn = strConn & "Trusted_Connection=Yes;"
Dim cnPubs As ADODB.Connection
Set cnPubs = New ADODB.Connection
cnPubs.Open strConn
geting error
[DBNETLIB][connectionOpen(connect().)]sql server not exist
please advice.
Thank you,
Yalon

Swift Programming Microsoft Excel Microsoft SQL Server 2005

Last Comment

ygnd

7/20/2008

ASKER CERTIFIED SOLUTION

ozi_lion

7/20/2008

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ygnd

7/20/2008

ASKER

Ozi, thank you.
It work fine.
Yalon

ygnd

7/20/2008

ASKER

Ozi, other question,
The connection above was related to DB and tables that I build manually with the SQL Server Management Studio Express. It works.
When i added new DB and populate it with my tables from access, using ODBC. it not work.
I get an error "invalid object name 'dbo.Items' (my table from access).
Please advice.
Thank you,
Yalon