Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem: Using SQLGetInfo()
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Problem: Using SQLGetInfo()
Miscellaneous
Thread ID:
00033607
Message ID:
00033607
Views:
86
I'm trying to use the ODBC function SQLGetInfo(), but I keep getting the error 'Too many arguments'.

The code I'm using is as follows:

***-----------start

#DEFINE SQL_DBMS_NAME 17

declare integer SQLGetInfo IN odbc32 integer, integer, string, integer, @integer

LOCAL lnHandle, lcRetString, lnOutputLen, lnInitLen
lnHandle = sqlconnect( "MyDSN", "sa", "" )

lcOutputString = SPACE( 300 )
lnOutputLen = 0
lnInitLen = 300

? SQLGetInfo( lnHandle, SQL_DBMS_NAME, @lcOutputStr, lnInitLen, @lnOutputLen )

sqldisconnect( lnHandle )

***------------- finish

As soon as I hit the SQLGetInfo line, I get the Too many arguments error.

Anyone got any suggestions?

Thanks,
Jamie
-----
Jamie Forgan
Senior Consultant
WST Pacific Pty Ltd
Next
Reply
Map
View

Click here to load this message in the networking platform