Prev: using Ms OutlookView
Next: VO Beginner: how to use Oracle with VO 2.6?
From: Geoff Chambers on 15 Oct 2006 17:04
I created the link server
It opens the server, but i get the invalid schema definition error.

I think maybe my ODBC connection may not be correct or something. I
created a system DSN called costcontrol with the start line =
"C:\Program Files\Sybase\SQL Anywhere 9\win32\dbserv9.exe" -d -c8m.
This works for my VO pplication



I then create the linked server called it CostControl, selected the
sybase provider, assigned Product name - ASAProv.90,
datasource=costcontrol, I entered nothing into provider string,
location, catalogue.


I the run the query select * from costcontrol..dba.costcodes, it starts
to load adaptive server, it takes a little while since it's trying to
load dbserv9, but it then returns the error.

Meinhard Schnoor-Matriciani wrote:
> Can you tell me in detail what you've done ? I've just tested it and had no
> problems.

From: Meinhard Schnoor-Matriciani on 16 Oct 2006 05:11
Hi Geoff,

I use the name of the database as product name and as datasource name. Make
sure that you use the right security setting on the security tab ( I use the
last option with a username and a password ). Finally I would advise you to
start the database as a service, make testing a little bit easier because
it's faster. And last but not least, I am using the "Sybase Adaptive Server
Anywhere OLE DB" driver ( so you don't need a DSN ).

Regards,
Meinhard


From: gchambers01 on 17 Oct 2006 11:16
Ok, here's what I did

create Linked Server called COSTCONTROL
Provide = Sybase Adaptive Server Anywhere Provider 9.0
Product Name = CostControl9
Data Source = CostControl9
Provider string is empty
Location = C:\Onsite
Catalog is empty

Security last option with userid and password

Server Options default
Collation Campatible = FALSE
Data Access = TRUE
RPC = False
RPC out = False
Use remote collation = TRUE
Coallation Name = empty
Connection Timeout = 0
Query timeout = 0


Tried providing the complete path and file name with extension to
datasource, I always get file not found. It only seems to load when I
use the DSN? Are you saying the way you do it, I shouldn't need an ODBC
connection setup?

Second question how do I set it up so the Sybase Service starts at
bootup? right now It loads when my application starts.

Can you recommend any good books on all of this?

Meinhard Schnoor-Matriciani wrote:
> Hi Geoff,
>
> I use the name of the database as product name and as datasource name. Make
> sure that you use the right security setting on the security tab ( I use the
> last option with a username and a password ). Finally I would advise you to
> start the database as a service, make testing a little bit easier because
> it's faster. And last but not least, I am using the "Sybase Adaptive Server
> Anywhere OLE DB" driver ( so you don't need a DSN ).
>
> Regards,
> Meinhard

From: gchambers01 on 17 Oct 2006 20:05
What do you mean by EBF's? I've also read where I may need to make some
changes to my database, I don't have the printout with me. I've
concluded that something needs updated for this to work.
Meinhard Schnoor-Matriciani wrote:
> Me again ;-)
>
> I just read that there have been some fixes in this area, do you have the
> latest EBF's installed ?
>
> Regards
> Meinhard

First  |  Prev  | 
Pages: 1 2 3 4
Prev: using Ms OutlookView
Next: VO Beginner: how to use Oracle with VO 2.6?