Problem with ODBC connection

  • Thread starter Thread starter Alain
  • Start date Start date
A

Alain

Hi to all,

I do not know if I should post this here or not but there it is,

I would like to know if anybody can explain to me why the error 3146 is
generated.
I started to get this error lately with my connection to an outside SQL
Server thru the internet.
We are based on the US east coast and the hosting server is on the US west
coast
I have 12 tables linked on a permanent basis, out of these 12, I need to
transfer data from 4 of the linked table so I can perform complex
calculation for reporting.

I have also notice that when I run my sub to transfer data from my 4 linked
tables to the db, the first connection will work fine but the other 3 raise
the error, I must close Access and re-open it to make it work again, but
this time one table at a time
Is there anyone who can explain to me the why's of this error so I can
understand and possibly make some modifications if needed

Many Thanks

Alain
 
You're right. This is the wrong place.

microsoft.public.sqlserver.odbc might be a touch better I think.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Slow VPN -- DB too slow when RecordSource loaded 2
read ODBC Connection 7
ODBC Update on a linked table 'table name' failed 1
Remote Printing 1
odbc connectivity to oracle 2
Can't connect to ODBC database 3
Allen Browne's function: "Duplicate record (and related child record)" -- my modified version doesn' 3
Copy Record Problem 3

Back
Top