Hello, new to the forum hope someone can help me.

I am using Advantage Database Server, locally on XP machine. Installed the ODBC driver for 9.0, and created a DSN. I am writing a small C++ utility program in VS2008, and trying to connect to a datadirectory on my C: drive. I successfully allocate all the handles and environment variables, but can not connect. It always returns "SQL_ERROR = -1";

I'm almost positive its my connection string, but I am not sure how to convert the string into a correct UNC Path. Here is my code.


rc = SQLDriverConnect(hDbc,
NULL,
"DataDirectory=C:\\C++\\UPHTest\\;ServerTypes=1;De faultType=Advantage;",
SQL_NTS,
OutConnStr,
255,
&OutConnStrLen,
SQL_DRIVER_PROMPT);

Thanks for the help in advance.