ODBC & Access 97
I am trying to import .tx file via oDBC into SQL 2000 DB from Access 97; right after couple seconds when I click import, I get "odbc call failed” I ran the tracing and it says fine with the connection. I even put the apps on the sql server and ran the import and I still get the odbc call failed; I have verified the odbc does have successful connection when I run the test from MSFT ODBC\system dsn; I have verified the ODBC CPTimeout on the client server and the Sql server, they all set to default at 60 secs, also add the connection time registry on both of the servers as well. Is there anything that I need look for specific?
Thank You,
I am trying to import .tx file via oDBC into SQL 2000 DB from Access 97; right after couple seconds when I click import, I get "odbc call failed” I ran the tracing and it says fine with the connection. I even put the apps on the sql server and ran the import and I still get the odbc call failed; I have verified the odbc does have successful connection when I run the test from MSFT ODBC\system dsn; I have verified the ODBC CPTimeout on the client server and the Sql server, they all set to default at 60 secs, also add the connection time registry on both of the servers as well. Is there anything that I need look for specific?
Thank You,