ODBC-call failed for some users

[jodjim]

I have an Access97 program in Citrix. It uses SQL pass-thru queries to grab data from a database with the following script:

ODBC;DSN=Payroll;SERVER=SERVSQL1;UID=reports;PWD=passwd;
DATABASE=PayNet;Address=SERVSQL1;Trusted_Connection=No;AutoTranslate=No"

My problem is, the program works with some users but others are getting the "ODBC - call failed" error. Since it is using a generic userID and password, and the same Access 97 in a server, while does it work differently with others? Could the individual user profile be an issue?

Thanks in advance for the help

 

[smedvid]

1st question is Does the "Payroll" ODBC Entry exist on the Citrix Farm/PC(s)? Remember when access via Citrix u are running a remote session from that Citrix PC..

Consider using DNSless references or perhaps an MS Access ADP. I've converted to ADP for Citrix based apps to improve performance.

htwh,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[jodjim]

Thanks smedvid,

Yes, ODBC Entry exist on the Citrix Farm/PC(s). I read somewhere in this forum about the DSNless references and conversion to ADP but if you have the infomation handy, would you mind posting it for me, please.

Thanks again.