Microsoft Dynamics GP (Archived)

OBDC Data Source on GP webclient

(0) Share

Report

Posted on by SenseiTebbayo

160

Hello All,

I am new to the community ad GP so please forgive my ignorance if this question sounds obvious.

I installed GP 2013 on a win serv 2008 r2 and it works fine. I just installed GP web Client (standalone) on the same machine but I cant log in to GP because the Datasource drop down is empty. it is not on the Desktop Client and the desktop client still works. I have tried creating a new ODBC data source but still doesn't work.

Any ideas on the way forward?

*This post is locked for comments

All responses (12)

Answers (1)

SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Hello, Thanks

I have resolved the issue. it helped.
Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Hi Tebbayo,

Please go through the below link that may helps to fix the above case

congruentdynamics.blogspot.in/.../gp-2013-web-client-login-issues.html
SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Hello,

I read you article here community.dynamics.com/.../adding-new-users-to-access-gp-2013-web-client.aspx.

Does this imply that you cannot login to GP webclient if your computer is not a member of the Windows domain where GP WebClient is installed?

because I am able to log in from the server computer (cloud) directly but I cannot access GP web client from an external computer on the internet out side of the domain.

I get this error

If that is the case, how doe a mac client log in to the system? Please can you shed more light on this?

Regards
Verified answer

SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Hello,

Thank you. I finally solved it. I was unable to create a 32 bit ODBC but I discovered that if you install GP afresh and you put in the name of your SQL server (to automatically create an ODBC connection), that connection will be a 32- bit connection.

o i uninstalled GP and re-installed with that setting and it worked!

Thanks for pointing me in the right direction
Suggested answer

soma 24,408 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

GP instance means, SQL server instance which is used for GP installation.

Create a 32 bit ODBC driver for your 64-bit operating system with following below link and try again.

www.mssqltips.com/.../create-a-32bit-dsn-on-64bit-machine-for-sql-server

Hope this helps!!!
SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Still Didnt Work. What do you mean by GP instance name?
SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

32 bit odbc

64bit os 2008 r2
SenseiTebbayo 160 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

I put in the name of the server computer in this spot

You mean I should put in the name of the SQL instance (MSSQLSERVER)

I will try reinstalling and see if jthat helps

THanks
Jonathan Fear on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

This is very strange because all this is doing is pulling from your machine that has session service installed on it or in your case the only machine.

Creating a 64-bit connection isn't going to work because GP uses 32-bit. What driver are you using for your ODBC connection?
Suggested answer

soma 24,408 on at

Like (0)

Report

RE: OBDC Data Source on GP webclient

Have you provided the correct SQL server(GP Instance) name while installing web client?

Please verify the server name and re-install with appropriate GP SQL server instance name in below screens.

Hope this helps!!!