By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,425 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Access 2003 runtime package connection problem

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.