ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> Connecting to ISNUMBER and other related files
http://www.istechforum.com/YaBB.pl?num=1344361884

Message started by daletone on 08/07/12 at 10:51:24

Title: Connecting to ISNUMBER and other related files
Post by daletone on 08/07/12 at 10:51:24

Does anyone know if it is possible to use ODBC to connect to the ISXXXXXX.B files? I have not had any luck with this so far. I am interested in obtaining the last Invoice number, Sales order number, etc from the ISNUMBER.B file but the error is:

Quote:

"ODBC – call failed. (Error 3146)

Using an ODBC connection, you tried to perform an operation on data in an ODBC data source. This error may occur when the ODBC data source is on a network drive and you are not connected to the network. Make sure the network is available, and then try the operation again."

I have tried ODBCDFF.RUN but that did not seem to work. Should I be able to connect to this file using ODBC with no issue?

Title: Re: Connecting to ISNUMBER and other related files
Post by Kelloggs on 08/08/12 at 07:18:11

Yes, it is possible and it works very well.
Tell us about your computer environment.....

Does it happen on all computers?
what OS are you using? NT, XP, 7?
Where is your Pervasive Server located? 2003, 2008?

:-/

Kelloggs

Title: Re: Connecting to ISNUMBER and other related files
Post by daletone on 08/08/12 at 13:57:27

I am operating Windows 7 64-bit and the server is running Windows Server 2003. I am going to try a few more things now that I know I *should* be able to connect to this file. Thanks for the uplifting news!

Title: Re: Connecting to ISNUMBER and other related files
Post by Kelloggs on 08/08/12 at 14:24:11

On your client computer, because you are using a 64bit system, dont forget to use the proper odbc exe

C:\Windows\SysWOW64\odbcad32.exe

8-)

Kelloggs