by I have two problems
The first one is If I by pass the DSN manager from Access I get an
ODBC - Call Failed error.
Syntax That I used is:
"ODBC;DRIVER={SQL
Server};SERVER=GLOBE;DATABASE=MAPPY;Trusted_Connection=YES"
but if i use the DSN It Works Fine.
The Second one is:
I am tring to execute a stored procedure from access 97.
I opened up the connection The Connection estabilshes fine(Using DSN) but
when I run this store procedure with a parameter, it runs for 30 Secs
and returns an error Execution Cancelled.
If create a stored querydef object in access it runs fine and it takes 15
minutes.
which in my case is not acceptable. That is why i really need to figure out
the problem.
Also other Stored procedures just like this one runs fine, with the same
commands..
Can Somebody help me here...
I would really appreciate your help..
Mani Solairaj