DSN syntax for ODBC (RDO) connection

[Former Member]

Hello !

I have an ACCESS database on a webserver and I wish to connect Crystal Report 2008 to it.

Till now I have always used connection with DB on the same computer as CR

so "Access/Excel (DAO)" was the way I connected to my *.mdb file.

This time, with my *.mbd file on a webserver, I thought ODBC (RDO) was the appropriate option.

This requires a DSN string (embedded in a file).

I guess my DSN syntax must be wrong because "Logon failed" keeps popping out then :

HY00 : "Invalid Datasource file" (loosely translated : excuse my French) Database Vendor Code :556

PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};SERVER=xxx.xxx.xxx.xxx;DBQ=D:\WS\abc\myDB.mdb

I am stuck : I hope this will look straight forward to you.

Thanking you in advance

Thib'

[Former Member]

Hi,

I don't see it anywhere that this is relevant to SAP anyhow....

Pardon, but this is SAP forum, search google for your answer...

You will get several hits...

All the best...

Regards.

Rajesh Narkhede

[Former Member]

> I don't see it anywhere that this is relevant to SAP anyhow....

I'm sorry : I realise I opted for the wrong category.

Maybe you should have told me that "Crystal Reports, Xcelsius and Interactive Analysis" > "Data Connectivity - Crystal Reports" would be a more suitable category.

Correct me if I'm wrong : Crystal Report is relevant to SAP ?

My apology for wasting your time.

Thib'