Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening database via ODBC
Message
From
28/03/2006 12:03:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Opening database via ODBC
Miscellaneous
Thread ID:
01108409
Message ID:
01108409
Views:
52
Hi all!
I'm trying to connect a DBISAM database via ODBC. Connection runs well I gess, I can list tales in database, but how can I read/browse a table?
Any help will be great.
Thank's in advance,
NPedro



****** SAMPLE CODE *******
nHandle = Sqlstringconnect("Driver={DBISAM 4 ODBC Driver};ConnectionType=Local; CatalogName=c:\datapath\data;TablePassword=323533")

*!* nHandle : returns positive number: OK

nTables = SQLTables(nHandle, 'TABLE', 'mycursor' )
Select mycursor
Browse

*!* browses tables names... inside database: OK

nResult = SQLExec(nHandle, 'use tablexxx')

*!* returns negative number: ERROR!!!
Next
Reply
Map
View

Click here to load this message in the networking platform