topic Re: ODBC Connection Error in Intel® Fortran Compiler

ODBC Connection Error

tom_c_lin — Fri, 11 May 2007 13:39:20 GMT

Good Morning Everyone,

I know this may not be the right place to post this question. But I bet some of you experts may know the answer or tell me a right forum for this type of questions. Recently I re-compileda SQL database-reading routines with IVF. The program works fine when I applied it to read database server (64 bit server) from my PC. But when I move the executable to the server and run the program from there to read the same database (whichresides on the same server). The following SQLErrorMessage appeared:

[Microsoft ODBC SQL Server Driver] Data Source Name not found and no default drive specified.

Isn't it strange? I can read the same database from my PCbut not from the database server itself. Any comments or suggestions? Thanks in advance. Good Day.

Tom Lin

Re: ODBC Connection Error

joerg_kuthe — Fri, 11 May 2007 19:39:50 GMT

If VS2005 is running on your server you can check whether youconnect to the server from within VS2005:

Open the "Server Explorer" (menu: View|Server Explorer)
mark "Data Connections" in "Server Explorer" view
click right mouse button and select in the shortcut menu "Add Connection..."
in the dialog "Add Connection" choose Microsoft ODBC DataSource and press OK
in "Data source specification" selecte "Use user or system data source name:"
in the list box below select the DSN you already have created (e.g. "ODBCTestAccess") and press OK

Now, the connection should be made and you should see an entry in the "Server Explorer". Open this and check if you can take a look into the "Tables" and see the
table(s) and its column names you are interested in. If this works then you certainly can get a local connection with the DSN on this PC. Thus, this should be possible with your Fortran program as well.

Just a last note: I am not sure if this "connect" facilitiy comes with VS2005 Standard Edition. If not, you might want to install "SQL Server Management Studio Express"

SQLServer2005_SSMSEE.msi

that can be downloaded somewhere from MS site (sorry I forgot where - on my PC "googling" for it gives me the German Microsoft website only that probably isn't much help to you).

Joerg Kuthe
www.qtsoftware.de

Re: ODBC Connection Error

tom_c_lin — Mon, 14 May 2007 19:22:29 GMT

Thanks Mr. Kuthe, for your suggestions andcomments. It is very nice of you. ... I already have found and corrected the problem in my server right after I posted this. Currently, I amtesting my program now. Good Day.

Tom Lin