sql server connect: SQL Server -- sql server connect

SQL Server

dungle
9/3/2003 10:06:18 PM

sql server connect:
Hi!

I have trouble with VB6.0 program. You know, I use VB program to connect
to SQL Server2000, it works well on Window 98 and 2000, but when I run
it on Window XP, error occured when I changed the default database of
SQL connection, and hereafter program code:

SqlCnn is Adodb.connection

sSqlCnn is SQL connection string with intialcatalog is "Product"

SqlCnn.open sSqlCnn

' change default database (initial catalog ) from "Product" to
"Customer"

SqlCnn.defaultdatabase = "Customer" ' Error occur

Please help me.

thank you in advance.

--

Re: SQL Server

Dejan Sarka
9/4/2003 8:42:21 AM

....And the error is?

--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

[quoted text, click to view]