471,310 Members | 1,150 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,310 software developers and data experts.

Access 2003 runtime package connection problem

Hello again,

I had posted over the past couple of days regarding a connection issue
I was having to my production database from an Access project. I
sorted that out by using integrated Windows login credentials instead
of the "sa" account and was able to connect to my production database
from the ADP running on my machine using my user account. I am not,
however, able to connect to the production database when I package up
the project with the Access 2003 runtime and try to run it from a
different machine also logging in with the same user account. That
account has permission to login to SQL Server (I'm running SQL 2000
Desktop Engine).

I'm getting the same error that I was getting when I couldn't connect
from my own machine before I change my connection string to integrated
security (that being "Invalid connection string attribute"
(-2147217843)). I'm running on Windows XP, Service Pack 2 and MDAC 2.8
SP1 on both machines in question; I updated the machine on which I was
trying to run the package from with SP2 and MDAC 2.8 thinking that this
was the problem. My connection string is as below. Any help anyone
could offer would be appreciated. I was certain that the MDAC
installation would have solved the issue. Let me know if I need to
provide any more information.

Sub OpenDbConnection()
On Error GoTo HandleError

'production connection string using Windows login
strConnection = "Provider=sqloledb;DataSource=domain\server02; " & _
"Integrated Security=SSPI;Initial Catalog=SubscriberMngt;"
'create new connection instance and open it using the connection
string
Set cnConn = New ADODB.Connection
cnConn.Open strConnection

Exit Sub

HandleError:
GeneralErrorHandler Err.Number, Err.Description, DB_LOGIC, _
"OpenDbConnection"
End Sub

Many thanks,

Barb

Nov 13 '05 #1
0 1486

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Francisco | last post: by
3 posts views Thread by Colin Chudyk | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.