|
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
| 
