Re: how to know wat is the data source name.

Data source can be created by running ODBC admininstrator (odbcad32.exe).
DSN name is not necessary to be the same as the SID value in the
tnsnames.ora.
If possible, I would suggest you to go through the source code and find the
name of DSN it is using. Create one with the same name using ODBC
administrator.

Let me know if you have more questions.

Bei

<ambrish.dwivedi@xxxxxxxxx> wrote in message
news:1127712985.464869.86600@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> hi there,
> i have got prob connecting to the oracle server through my vb6 client
> server application.while setting the dsn entry i dont know the name of
> the data source,so is there any entry of it in the server.this is a
> prebuilt application which on running gives
> "data source not found no default driver specified error "
>
> is the data source name same as the SID value in the tnsnames.ora file?
>


.

Relevant Pages

  • Re: Use of VisualFoxpro 8 data source.
    ... You will either need to make the connection via MS Query (it's on the Tools ... menu in the Select Data Source dialog box) or using VBA. ... > An existing driver for VFP tables on the 'User DSN' tab. ... > An existing driver for VFP tables on the 'System DSN' tab. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: "Word was unable to open the Excel data source" Asp.net Mailme
    ... (even though it is Excel, ... to check that the account has access to the ODBC DSN. ... >> its data source when OpenFileName executes. ... >> Peter Jamieson ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word could not reestalish a DDE connection to ACCESS DB
    ... OK, You must be using Word 2002 or later to have the OLEDB option, so ... know at this point that the .dsn points to a .mdb, ... if everyone else is using DDE to open the data source ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Use of VisualFoxpro 8 data source.
    ... > Control Panel) and create a DSN for FoxPro. ... Once you have created a DSN, ... > the data source selection process, select the dbf, and select ... The VFPODBC.DLL driver is present in ..\system32 and correct. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: how to know wat is the data source name.
    ... Bei Zhu wrote: ... > Data source can be created by running ODBC admininstrator. ... > name of DSN it is using. ...
    (microsoft.public.data.ado)