Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-25 : 08:49:48
|
| Yaniv writes "Hi, I'm working in "Imagine" company which is in the Live Customer Support Solutions business. I'm the database team leader, we have SQL Server 2000 sp1 as our RDBMS. We developed a dll in COM with functions that runs simple sql query. The connection to the database is with ODBC (MDAC 2.6). I use a new SQL user to connect to the database with all the permissions to the database. this user is the one that in the ODBC DSN. There are several process that connecting to the DB at the same time using this dll, and in some cases, when the system is already running, I got error: Connection failed: SQLState: 'S1000' SQL Server Error:998 [Microsoft][ODBC SQL Server Driver]Unable to load communication module. Driver has not been correctly installed.I also get an ODBC error: The program ... attempted to call the function SQLGetPrivateProfileStringW which is not supported in the loaded ODBC installer DLL (C:\WINNT\system32\odbccp32.dll)I re-installed the MDAC2.6 it didn't help. I changed the connecting to Connecting string not using DSN but IP address but it is the same problem (with out this message, the programm didn't run well). I installed the SQL client on the computer with this problem, although I donot need it, it didn't help. Do you have any idea? Thanks, Yaniv" |
|
|
|
|
|
SQL Server error