MS SQL Server ODBC - Multiple connections to SQL 2K5 Express..

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

Multiple connections to SQL 2K5 Express..

Wade

2005-11-22, 8:23 pm

Does SQL 2005 Express allow for multiple connections thru ODBC?

If I have an executable running that is populating a table, I cannot Link or
view that table using Access as the frontend (ODBC connection failed). If I
have the table opened in Access (which is linked to the sql table), I cannot
run the executable (errors out with an unable to connect error). I can do
one or the other, but I cannot do both. Is there a setting in SQL Express
or ODBC that I'm missing?

Thanks in advance.

Sponsored Links