Jet - Db Connection

[Guest danny]

Hi

 

I can not use ODBC connection so I have tried to use this:

 

Provider=SQLOLEDB.1;User ID=xxxxxxx;password=xxxxxxxx;Initial Catalog=intercash;Data Source = 192.168.0.44;Use Procedure for Prepare=1; Auto Translate=True;Packet Size=4096

 

I can not connect to the DB (name: intercash), I get this error:

 

143528.66 0 [Get Company ID] DB Query

143528.67 0 Jet mode used (To use ODBC mode specify ODBC Connect string)

143528.67 0 ERROR 5.1.3000 Database file not found: intercash

143528.69 0 Hanging up call... [srlib 282]

 

How can I connect to the DB?

(Module: Get Company ID)

 

Danny.

Desktop.zip

[Guest Guest]

This connection string is working perfect on an ASP page.

[SupportTeam]

From the trace provided it looks like no ODBC connect string was specified in the DB Query module [Get Company ID]

 

Can you post your script here?

[Guest danny]

Hi

 

I have attached the script as ZIP file in the first message.

 

Thanks.

 

I can not!!! use ODBC connection, so I have tried to use Jet mode, with no luck :-(

[SupportTeam]

Desktop.zip does not contain any script - just a trace of a call and a log file...

 

What database are you trying to access? Jet mode is only for local MS-Access type databases - for all other databases you need to set up the ODBC Data Source and ODBC Connection... The databases' Help file should contain more info on how to correctly specify an ODBC Connect string to work with the database that you are using...