Access and sql server problem

[amjad]

i have two sql server 2000 and access for front end. with one server which
is for developement purpose working fine .... i can send data to update and
it is diong that with out problem. but when i change the connection string to
live server. it gave me connection time expired. does any one know where i am
wrong . i am suing below connection string .


Constring = "Provider=SQLOLEDB;Data Source=LiveServer;" & _
"Initial
Catalog=MyDatabase;UID=userme;PWD=123456;Trusted_Connection=Yes"

thanks

 

[Alex Dybenko]

Hi,
looks like something wrong in your connection string - you specify user and
password, and same time use trusted connection. Try to use connection string
builder - it will help you to build it correctly (and test it also)

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[amjad]

the connection string is ok because its working with development sql server
not my live sql server .....

 

[Nikos Yannacopoulos]

Quite likely a security issue on the SQL Server side; cross-check your
security between the two servers.

HTH,
Nikos

 

[Alex Dybenko]

well, then check, that LiveServer name is correctly resolved, perhaps you
need to add alias using cliconfg.exe

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com