Error on one pc, other pc runs page without a problem

Hi,

I have a asp page connecting to a SQL Server DB. On my pc it works without a problem. When I try it on someone elses it says it has incorrect db driver or db source not found.
My initial though was that the 2nd pc had an old version of the page cached. Turns out both pcs have been told to search for new versions of pages whenever they visit it. I have set the response.expires to -1.
Any other ideas?

Cheers
itsallmemanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

itsallmemanAuthor Commented:
Is it possible that the 2nd pc genuinely cant connect to the db while mine can?
Doesnt make much sense to me.
0
mk_bCommented:
can you post the part of the code where you are getting the error?

../mk
0
itsallmemanAuthor Commented:
dim EditTablesRS, EditTablesConn

Set EditTablesConn = createobject("ADODB.connection")
EditTablesConn.open Session("Employee")

This is the first few lines of the page, the error pops up as soon as it trys to open the connection. The db name is definitely right.
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Marv-inCommented:
Do you use a dsn to connect? if so the 2nd pc will need that created as well. Or the 2nd pc doesnt have the exact version of the sql server odbc driver that you are specifing in your connection string.

what does your conenction string look like?
0
mk_bCommented:
is the connection string right?
0
nurbekCommented:
is the session employee returns value

check it
Response.write(Session("Employee"))
Response.End()

0
nurbekCommented:
by the way
it not a good idea
keep the connection string on the session
0
mk_bCommented:
dbConnStr = "PROVIDER=MSDASQL;DRIVER={SQL Server};SERVER=YourIP;DATABASE=Northwind;UID=YourUsername;PWD=Yourpassword;"


0
itsallmemanAuthor Commented:
My connections string looks like this:
PROVIDER=SQLOLEDB;DATA SOURCE=Server-name1;UID=webreports;PWD=webreports1;Database=employee;Network=dbmssocn"

I did just sort the problem.
There is a file to be included that contains the conn string, I was trying to connect to the db before the file had been included.
What doesnt make any sense to me is that it worked on my pc.
0
mk_bCommented:
computers go figure...

../mk
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.