fp ODBC help, AGAIN

[Walter Vaughan]

> I am getting quite frustrated getting fp to set up a low level link to our
> MRP software.
>  
> So I thought I'll begin to set up a High Level filePro ODBC file and see
> what it sets as the link.  This is what it set:
>  
> DSN: ODBC; DSN=Server2010-IERP60; Description=Intuitive ERP Datasource;
> WSID=virtualxp-51168;
> Database=IERP60; Trusted_Connection=Yes; UseProcForPrepare=0; QuotedID=No
> Table=IMA

So you are running Active directory, and you have proper permissions from
your AD account to the IMA table? I say that because of the Trusted
Connection string. Can you connect to that table from SQL Server
Management Studio to that table without using a password?

http://stackoverflow.com/questions/5029014/how-to-add-active-directory-user-group-as-login-in-sql-server

> Anyway I tried to use the above info in the ODBC samples2 file as listed
> below
>  
> Driver Info driver={MySQL ODBC 3.51 Driver}
> DB Info database=IERP60; server=server2010-IERP60; UID=sa; password=
> Table Name IMA

You can't or rather anything recent should not allow a blank sa pasword
account. And who would setup an sa account on a mySQL server, that's crazy
speak.

So you are trying to connect to both SQL server AND mySQL? Or just
Intutive's DBMS? I thought Intutive was only MS SQL Server.

Be careful with your ERP. Last thing you want it to start dinging up
anything that has to do with transactional General Ledger stuff.