Mailing List Archive


Back to the month index Back to the list index
Nicolas Beaufils (nico@justine.umontreal.ca)
Wed, 11 Sep 1996 10:24:06 -0400 

Message-Id: <199609111422.KAA05893@Isis.Justine.UMontreal.CA>
From: "Nicolas Beaufils" <nico@justine.umontreal.ca>
Subject: [mSQL] Access95 with ODBC to MiniSQL
Date: Wed, 11 Sep 1996 10:24:06 -0400

Hello,
        I want to use Access95 as a front-end to Mini-SQL. Unfortunately, each
time I try to import a database from msqI in Access or export one to msql,
Access crashes.
        I've read the FAQ, and I scanned through the mailing list archive. I know
the msql server works, and I think I've followed the setup steps correctly.
In the control panel, ODBC 32bits icon is configured correctly with the
mSQL ODBC Driver installed and a data source defined.
        I can't see what I am doing wrong. Here's my 'odbc.ini' file :

[ODBC 32 bit Data Sources]
MS Access 7.0 Database=Microsoft Access Driver (*.mdb) (32 bits)
dBASE Files=Microsoft dBase Driver (*.dbf) (32 bits)
Excel Files=Microsoft Excel Driver (*.xls) (32 bits)
FoxPro Files=Microsoft FoxPro Driver (*.dbf) (32 bits)
Paradox Files=Microsoft Paradox Driver (*.db ) (32 bits)
Text Files=Microsoft Text Driver (*.txt; *.csv) (32 bits)
BD Test=mSQL ODBC Driver (32 bits)

[MS Access 7.0 Database]
Driver32=C:\WINDOWS\SYSTEM\odbcjt32.dll

<--cut (not relevant text removed)-->

[BD Test]
Driver32=C:\WINDOWS\SYSTEM\MSQL32.dll
Description=BD Test
Server=isis
Database=test

The 'odbcinst.ini' file contains the following lines :

[ODBC 32 bit Drivers]
Microsoft Access Driver (*.mdb) (32 bits)=Installed
Microsoft dBase Driver (*.dbf) (32 bits)=Installed
Microsoft Excel Driver (*.xls) (32 bits)=Installed
Microsoft FoxPro Driver (*.dbf) (32 bits)=Installed
Microsoft Paradox Driver (*.db ) (32 bits)=Installed
Microsoft Text Driver (*.txt; *.csv) (32 bits)=Installed
SQL Server (32 bits)=Installed
mSQL ODBC Driver (32 bit)=Installed

[Microsoft Access Driver (*.mdb) (32 bits)]
Driver=C:\WINDOWS\SYSTEM\odbcjt32.dll
Setup=C:\WINDOWS\SYSTEM\odbcjt32.dll
32Bit=1

<--cut (not relevant text removed)-->

[mSQL ODBC Driver (32 bit)]
Driver=C:\WINDOWS\SYSTEM\MSQL32.dll
Setup=C:\WINDOWS\SYSTEM\MSQL32.dll
32Bit=1

I've tested the setup with the 'Msqlrs32.exe' program and it works....
Any kind of help would be appreciated !!!

My 'mslq.ini' file contains the following :

[Server]
IP=isis
Port=1112
Username=root

Thanks for any kind of help 

--
Nicolas Beaufils
nico@justine.umontreal.ca

--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com.  Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!