ODBC
04 September 2002, 01:38 PM
#1
Scooby Regular
Thread Starter
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
We use Maximizer Enterprise 2000 as our contacts manager. I want to use ODBC to connect to the data using Access 2000. Have succesfully created a system dsn and can link to some of the tables. One Maximizer table, Notes, keeps giving the error in Access; ODBC - call failed. Used the same ODBC dsn in excel and connected to this table with no problems. Tried MS knowledge base. No help. Tried Multiactive, no help. Anyone any idea why this table wont connect in Access?
04 September 2002, 02:06 PM
#2
Scooby Regular
Thread Starter
Join Date: Jun 2002
Location: Perth, Western Australia
Posts: 1,866
Likes: 0
Received 0 Likes
on
0 Posts
More info...
Just tried opening the Access db on another pc that's got the Maximizer ODBC driver. Differnt linked tables refused to open giving the same error. Very strange...
Just tried opening the Access db on another pc that's got the Maximizer ODBC driver. Differnt linked tables refused to open giving the same error. Very strange...
04 September 2002, 04:46 PM
#3
Scooby Regular
Join Date: Sep 1999
Location: Bedfordshire
Posts: 4,037
Likes: 0
Received 0 Likes
on
0 Posts
what db is the maximizer db, a proprietry one? Not a very helpful error message for sure, maybe it's to do with translation of a column type in that particular table. Cant think of anything else
Gary
Gary
04 September 2002, 06:01 PM
#4
Scooby Regular
Join Date: Jun 2000
Posts: 3,783
Likes: 0
Received 0 Likes
on
0 Posts
Not always a good idea to use Access to connect to a foreign database via ODBC as you can get unexpected results and problems.
Maybe's you'd be better off finding a proper client instead.
Maybe's you'd be better off finding a proper client instead.
Thread
Thread Starter
Forum
Replies
Last Post
swisstonihasher
General Technical
6
08 March 2009 08:05 PM