sql server odbc: SQL ODBC Connection Error -- sql server odbc

SQL ODBC Connection Error

TomLin19
5/11/2007 8:25:01 AM

sql server odbc: Good Morning Everyone,

I recently re-compiled a SQL database-reading program with Intel Visual
Fortran. The program seems working fine when I tried to read data in a 64-bit
server from my PC. But when I moved the executable to the server and tried to
read the same data from the server (now the executable and the database
reside on the same machine). The following SQLErrorMessage appeared (and the
data-reading process was failed):

[Microsoft ][ODBC SQL Server Driver][SQL Server] data source name not found
and no default drive specified.

Isn't it very strange? The program can read data from a PC, but not from the
server where the database resides. Any comment or suggestions? Thanks a lot.

Re: SQL ODBC Connection Error

Sue Hoegemeier
5/14/2007 7:32:57 PM

Is your PC is 32 bit and the server is 64 bit. The program
sounds like it could be trying to load a driver that exists
for 32 bit but not 64 bit. Or maybe it's how it's
referencing the driver.
Problem seems to be in that area somewhere.

-Sue

On Fri, 11 May 2007 08:25:01 -0700, TomLin19
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.