2. ASPRunnerPro General questions
  3. Problems with linked ODBC tables in Acces
This topic is locked

Problems with linked ODBC tables in Acces

 		10/25/2006 4:40:42 PM
ASPRunnerPro General questions
U
 uros author

In MS Acces I have one linked ODBC tabel from PervasiveSQL database. I can't list this tabel in explorer. It return this error:
Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'Horjak' failed.

URL /Project1/MYPOZICIJE_list.asp

SQL query select [Klasifikacija], [EM], [Naziv_pozicije] From [MYPOZICIJE]
What is wrong here....
Sergey Kornilov admin 10/25/2006

Could be a permissions issue if IUSR_... user do not have access to 'Horjak' datasource.
U
 		uros author 10/27/2006

With permisions is everything ok, if I made aplicatin only with DSN "horjak" it's works fine, but if i made aplication with MS acces database where is included linked tabel to DSN "horjak" send me this error. Anyone know what is wrong here. Made a test: create a DSN to some database (eeg. MySQL), then create MSAccces database where is linked tabel to this DSN and create aplication with ASPrunner.... Thank you for any help or information on this problem.
Best regard,

Uros
F
 		fnqchick 2/20/2007

With permisions is everything ok, if I made aplicatin only with DSN "horjak" it's works fine, but if i made aplication with MS acces database where is included linked tabel to DSN "horjak" send me this error. Anyone know what is wrong here. Made a test: create a DSN to some database (eeg. MySQL), then create MSAccces database where is linked tabel to this DSN and create aplication with ASPrunner.... Thank you for any help or information on this problem.

Best regard,

Uros


Hi Uros,
Did you ever fix this?
Cheers.
U
 		uros author 3/26/2007



Hi Uros,
Did you ever fix this?
Cheers.


No I didn't. I link Pervasive to MSSQL...
H
 		Happening 3/26/2007

I also had problems with linked tables in Access. (a linked table to ORACLE db)
I changed the dbconnection.asp.

ASPRUNNER uses the Microsoft Access Driver for the ODBC connection.

I now use the Microsoft.Jet.OLEDB.4.0 driver to connect to de access database and it works for me.
U
 		uros author 3/26/2007

Thank you, now this works at me too... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=16516&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />