You are not logged in. You can browse in the PowerBASIC Community, but you must click Login (top right) before you can post. If this is your first visit, check out the FAQ or Sign Up.
For sure its possible if there is an ODBC datasource for each server. (Create database will be MSSQL-specific, but all the other stuff is 'generic' to ODBC)
There's probably a COM-based way, too.
I didn't have a clue what 'SQLDMO' was, so I "googled" for it. It appears to be a documented Microsoft thing, but it is COM-related so I don't know squat about it.
When upgrading the old PowerBASIC ubb forums to the new vBulletin forums, the upgrade scripts vBulletin provided where not very good. I cannot blame vBulletin as the old ubb forums where in a very old format. I created a PBCC and SQL Tools application to read the old forums and create the MySQL tables with the necessary information. As you can see it did (not a 100%) a pretty good job - which was my fault and not SQL Tools.
You can certainly use the ODBC API but that is a pain and I highly recommend PerfectSync's SQL Tools.
In my experience SQL Tools was easier to develop than the sdk odbc api and virtually no difference in speed. I didn't find anything you couldn't do with SQL Tools.
User to user discussions about the PB/Win (formerly PB/DLL) product line. Discussion topics include PowerBASIC Forms, PowerGEN and PowerTree for Windows.
It contains a demo that attempts to connect either to MSDE or SQL Server. If it manages to connect it creates a simple database on the SQL Server and then creates a table within the database containing a few sample fields. Then it reads a few records into and out of the database and displays the info in a console window. It is a Console Compiler program. If you don't have the Console Compiuler I'd recommend converting all the Print statements to Print #FileNum, using an output text file.
The program was tested on several of my computers and works without fail, but nontheless I can't guarantee it will work for you. If it does or doesn't I'd appreciate hearing about it.
The program uses direct ODBC function calls with a minimum of wrappers to take the 'edge' off them. For most folks ADO or SQL Tools would probably be a better ottion. I've used ADO with SQL Server too and that works fine.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, and to analyze site activity. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment