Hi,
I read a little in the forums but couldn't find exactly what I was looking for. I'm trying to synchronise a mysql database from a webserver with the Maximizer DB in our office.
I'm using php and the odbc_connect() function. Firstly I created a system DNS and connected successfully from my local webserver to maximizer on the same machine, but now I'm having trouble connecting over the Lan to the system DNS. I'm not sure if my connection string is correct but I keep on getting the following error:
SQL error: [Maximizer][ODBC Driver][Btrieve Database]Bad/missing ODBC.INI or <DataDirectory> entry in it, SQL state S1000 in SQLConnect
My connection string is the following:
"DRIVER={Maximizer ODBC Driver}; SERVER=192.168.0.4; DSN=EsconaTutorial; UID=MASTER; PWD=CONTROL”
--
Edit: I played around with the connections string on my local machine, with the local maximizer db and found that the SERVER part of the string doesn't seem to do anything, eg. when I type in a random IP it still connects fine. Also when I add the driver={} part, it gives me the same error as above! so leaving out the driver and server I'm basically left with DNS="test" as a connection string, but this won't do for a remote connection...
--
How should I go about connecting remotely to the Maximizer db/system DNS? Read something about ODBTP but not sure if I do need it...
Any help would really be appreciated! Please let me know if you need more information.
Thanks
Original Post