Identify the SQL Server used in GP

(0) Share

Report

Posted on by Edie Williams

395

Hi,

I need to identify the name of the SQL Server to where GP is connected, I already check the ODBC's configuration but there's no reffence to GP. Also checked the SQL directory in the GP installation but it only have .dll's

*This post is locked for comments

All responses (3)

Answers (1)

Richard Wheeler 75,730 on at

Like (0)

Report

Re: Identify the SQL Server used in GP

If you search for 32 bit odbc 64 bit computer or other variations there of, you wouild find it.

support.microsoft.com/.../942976

Here is the technical blurb.
Edie Williams 395 on at

Like (0)

Report

Re: Identify the SQL Server used in GP

Thanks, I would never found this by myself, after days on google...
Verified answer

Richard Wheeler 75,730 on at

Like (0)

Report

Re: Identify the SQL Server used in GP

the ODBC connection to GP is done via a 32-bit ODBC driver. If you are on a 64 bit computer and just go to Admin Tools->ODBC you will not see anything. Go out to your Windows folder and then SysWOW64 and look for ODBCAD32.exe.