Home > Archive > MS SQL Server ODBC > March 2006 > connection string in passthrough queries









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author connection string in passthrough queries
Sam

2006-03-09, 7:23 am

i am useing an odbc connection with sql server authentication
for passthrough queries i use as connection string
"ODBC;DRIVER={SQL Server};SERVER=Serve
rName;DATABASE=MyDb;
UID=UserName;PWD="
when user B works on user's A computer i get as result for "select
user_name()" A as name even connection string
includ's B name
what can be wrong?

thanks







Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com