I've not been able to find out how to pass a null value to a stored proc
via a pass through query. If I'm executing the sproc in the sql server
tooling, I can use Null as the placeholder for a null value. But nothing
I've tried in the pass through is interpreted properly by sql server.
I'm writing the pass through sql dynamically.

This works:
EXEC procMyList 1, 2, 3, 't' , 0, 0, 0, 0

These fail
EXEC procMyList 1, 2, 3, , 0, 0, 0, 0
EXEC procMyList 1, 2, 3, null , 0, 0, 0, 0

This works when executed directly on sql server
EXEC procMyList 1, 2, 3, Null, 0, 0, 0, 0

I could convert the null to 0 and test for that in the sproc but at
least I'd like to know if my original approach can be made to work.

brand cialis for order in Lashburn buy cialis in great britain Where to buy cialis in SA brand cialis or super cialis Where to buy cialis in Kentucky

+++ MEN'S HEALTH +++ MEN'S HEALTH +++ MEN'S HEALTH +++
+
BUY CHEAP CIALIS - ORDER CIALIS ONLINE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-CIALIS-BON-MARCHE/
http://jhku.net/ACHETER-CIALIS-SOFT/...

achat valium soft generique dans commande acheter valium en France corpus generique pharmacie commander comprime de achat valium canada achat valium belgique le plus bon marche

citrate de Finasteride soft en France acheter propecia canada comprimes de propecia acheter propecia canada propecia belgique par email

commander comprime de meridia in Granum acheter meridia canada concernées par cette pharmacie en ligne canada comprimes de meridia Achat meridia Pro

cialis belgique in Falkland cialis belgique acheter cialis bon marche cialis suisse aucune prescription acheter cialis canada en ligne

privatermittler in Soltau privatdetektiv stuttgart privatdetektiv dortmund detektei schleswig privatdetektiv film

detektei condor in Peine detektei coburg detektei kiel detektei muenster detektei frankfurt main

Hi,

At startup of a database, I would like to first check if the needed
ODBC driver is installed on the machine, and if it is, also check
whether the needed DSN is configured.

The point is to give a helpful error message, adapted to the
situation. Like:

"Error: missing ODBC driver. Run "\\server\share\odbc-install.cmd" on
this system to be able to use this database"

or

"The database connection is not configured on this system. You need to
run '\\server\share\setupDSN.reg' to configure the connection"

Is there a way to retrieve the list of ODBC drivers from VBA code? And
a list of DSNs?

Thanks,

RD

A couple weeks back I posted a problem with selects from combo boxes
causing additional logons with SQL Sever backend. (And thanks to those
who responded.) However, upon further research we discvered it's actually
subforms causing the problem. We're using windows authentication and the
Native Client driver. Any ideas?