JDBC ERROR

[Former Member]

I am using access from which i am fetching the records using JDBC Sender Adapter type.

I have created the .mdb file in c:
access\sender\.student_Database.mdb i am getting following error

Sender Adapter v2108 for Party '', Service 'ARISEN':

Configured at 2007-07-17 05:01:16 UTC

History:

- 2007-07-17 05:07:00 UTC: Retry interval started. Length: 10.000 s

- 2007-07-17 05:07:00 UTC: Error: Accessing database <i><b>connection 'jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:\ACCESS\Sender\Student_Database.mdb' failed: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.</b></i>

what might be the problem.

regards

Nash tech

[Former Member · Accepted solution]

Nash,

Where is the .mdb file placed? In your local PC? Place the file directly in XI server and give it a try.

Regards,

Jai Shankar

[Former Member · Accepted solution]

HI

We are restircted to place the file in Xi server & geographically its at different location.

We aer asked to place from Local folder, how to solve.

Regards

[Former Member · Accepted solution]

Place the file in a folder that can be accessed by XI server (shared folders).

Regards,

Jai Shankar

[Former Member · Accepted solution]

Dear Jai

On My PC

C:\Sender\....mdb is the folder path & c as well as sender folders are given shared access,still any thing missing??

Regards

[Former Member · Accepted solution]

Hi Wong,

If you specify C:\ACCESS\Sender\Student_Database.mdb' in your communication channel. XI will lokk for the file in XI application server direwctory and not your PC. How do you access Student_Database.mdb file from another machine?

It can be some thing like <yoursystem IP>\Sender\Student_Database.mdb or some thing similar. Try to access the file from your nieghbours system and find the path to be used and specify this in the comm channel.

Regards,

Jai Shankar

[former_member185845]

Hi Wong,

Jai is right in his discussion, check out the folder

and the access using Ip address.It should work

Regards

dasari

[Former Member]

Wong,

It complains about the Driver for MS-Access. Make sure you are specifiying correctly. Also check this weblog for some help on this integration:

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Regards,

---Satish