Right now one have to SAxxxx etc instead of generic objects
if there is factory provide, one could easily replace ms sql server or even
Oracle with Sybase SqlAnywhere.

Maybe I do not understand the question but there is a
factory object introduced in V10. See SAFactory class.

Is the DbProviderFactory stuff not working for you as
expected maybe?

"gg" <gg (AT) nowhere (DOT) ca> wrote

I can connect in .net application using "dataset=datbasename" as well as
using sybase central however I can not use studio's data explorer
using the dataset=.. I can of course use SA...stuff to do all data
retrieval, connection, manipulation.

That is fine for new application that is designed for working with SA only

However, for application designed to be adaptable using dbProviderFactory
stuff, I don't seem to be able to get it going may be I still green and
ignorant in that area.



"Nick Elson" <@@@nick@@@.@@@elson@sybase@@@.@@@com@@@> wrote

It may also be due to my green-ness as well.
[there is apparently and ASAFactory in later
versions of the 9.0.2 stuff too]

Okay, here is a bunch of things to look into.

1 - Have you properly installed for VS8 already?
There is an installer in win32\VS8 for that purpose.

2 - Find out with .Net Framework you are using and
what you have registered (Your Admistrator group
of programs can have either or both of these menus:
Microsoft .NET Framework 1.1 Configuration
Microsoft .NET Framework 2.0 Configuration
Launching each should tell what version and patch
you have ... and ... see next bullet ...

3 - Check to see if you have multiple ASA 9.0.x ADO.Net
providers registered in the Global Assembly Cache?
You can use GACUTIL -l or the
"Manage The Assembly Cache"
under your (1 or 2) '.Net Framework n.n Configuration'
utility. Look for duplicates (with different builds) of
the provider classes/interfaces you are working from.

[hint: you may need to remove duplicates and possibly
clean this completely out and redeploying again]


4 - Also check out the information in the other active thread on this
newsgroup "Sybase AsaClient and DbProviderFactories"
to see if you have anything like that happening (like missing files
in subdirectoreis or older/unregistered assemblies).


"gg" <gg (AT) nowhere (DOT) ca> wrote