Basic MS SQL 6.5 questions...

[xBaseDude]

Hello!

I am a VFP developer attempting to learn about using FoxPro to access SQL db.

I'll be very honest, and tell you I don't know very much about the MS SQL service.

I run Win98 on my machine, and have MS SQL 6.5 installed.

I working on a learning assignment that has me upsizing a FoxPro database to the SQL environment, then accessing the SQL db thru VFP to make the connection.

I have never installed a server before and am lost in a few places. I understand the need to make an ODBC connection, and have a sql driver installed on the machine.

I get lost on the dialog boxes, where it starts to ask for information like "Server Name:" (okay how 'bout Fred!).

Does anyone have the patience to work w/me on this and field a few questions from a rank amat.

TIA - Wayne

 

[xBaseDude]

...anyone

 

[tombos]

You're probably not going to get many takers on this. I've never done what you're attempting, but I have replaced one system that was precisely what you're describing. It was incredibly unreliable and slow. Of course, that could have been the implementation, but there appeared to be some real problems with indexes getting corrupted and such.

Visual Foxpro is not the best tool to use as a front end for SQL. I wrote Foxpro for years, and it was a great language in its time. I know how hard it is to step out from what you know well, particularly if you have a huge body of Foxpro code to port. My advice is to bite the bullet and move to VB. It's easier to learn than VC, and it'll make you much more valuable in the marketplace.

Also, you definitely don't want to work on SQL 6.5. Even if you have to purchase the upgrade out of your pocket, SQL 7 is way, way more stable and easier to use.