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 machine on our network which is
the production environment. I have built an Access 2003 front end
application which connects to this database. This works fine locally,
as you would expect. I successfully installed the database on the
production machine and am able to connect to it via Access 2003 (using
the Data Link Properties window) and from third party database manager
software (similar to Enterprise Manager). I am not able to to connect
to the database via my application.
I am using the "sa" account with a strong password. This is my
connection string:
strConnection = "Provider=sqlol edb;DataSource= server02;User
Id=sa;Password= strong;Initial Catalog=Test"
The error I'm getting is:
"Connection cannot be used to perform this operation. It is either
closed or invalid in this context."
The connection string is the only thing that changes in my code when I
switch from my local to my production environment. Is there some
reason that I can't use the "sa" account in this fashion that I'm not
aware of? I'd rather not use integrated security for simplicity's sake
as this is a small, internal application. Also, I would have thought
that if that was the issue, I couldn't use "sa" at all, even locally.
I have posted to the SQL Server group already but thought someone here
might have some advice to offer.
Thanks,
Barb