473,396 Members | 1,760 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 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
Set cnConn = New ADODB.Connection
cnConn.Open strConnection

Exit Sub

GeneralErrorHandler Err.Number, Err.Description, DB_LOGIC, _
End Sub

Many thanks,


Nov 13 '05 #1
0 1581

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Barb | last post by:
Hi there, I sincerely hope that someone out there can help. I have two instances of the SQL 2000 Desktop Engine running. One is on my local machine for development and the other is on another...
by: Francisco | last post by:
Hi, How can I use a MS-Access DB in a computer without Access installed? I read something about a "runtime" utility, but I don't know how to use it. Any help? Thanks
by: trustme1 | last post by:
I am wanting to be able to write reports against an ms-access database that is part of another package. I only want to report from the database. What I need is a package that will allow me to...
by: Colin Chudyk | last post by:
Hi, Here is my situation. Can anyone provide insight? I have developed a database in Access 2002. I am planning to distribute it as a split MDE (front) / MDB (back) to be used by the Access...
by: Aliza Klein | last post by:
Apologies in advance as I am SURE this has been asked 100 times - but I haven't got a simple answer: I have MS Office XP Developer and have created an installation package (with the runtime) for...
by: Lauren Wilson | last post by:
I have a desperate short term need for a way to install Access 2003 runtime on client computers. I have the proper license to do so but I cannot seem to find the files to do it like we did with...
by: B1ackwater | last post by:
We've fooled around with Access a bit, but only using the single-user store-bought version. It seems to be a good database - versatile and infinitely programmable - and can apparently be used as a...
by: Sebastian | last post by:
Hello I develop my applications in Access 2002. My development system is running Windows XP SP2 and I have Microsoft Office XP Developer. Microsoft Office XP is at SP3. I used Inno Setup (great...
by: kfry | last post by:
I am having an issue maybe someone can help with. I have written an application with Access 2003 on my XP pc. I then package it and install it on my VISTA Access 2007 PC. When I do this the wrong...
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

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.