>>>I'm having some problems with a connection string. It says,"
>>>Error at connecting
>>>Data source name not found and no default driver specified
>>>
>>>The connection string is:
>>>lcConnStr = "driver={mysql odbc 3.51 driver};server="+ALLTRIM(settings.server)+";uid=sbcpro_"+ALLTRIM(settings.user)+";pwd="+ALLTRIM(settings.pass)+";option=3;database="+tDatabase
>>
>>No problem, I'm glad to help. I saw today a question about mySQL Re: MySQL Thread #1131600 Message #1131651
>
>Okay. Thanks again. We'll look into that thread and see what gives.
>Basically, we're doing a VFP app using a local database, and then
>we're copying the data over to a MySQL database backend, which
>we use for display on the web via PHP. I'm guessing that this is probably
>a common situation around here? :)
>
>Regards my friends,
>
>Randall

In my former company we were using ASP and SQL Server the same way. In other words, instead of having all our data in SQL Server, we just copied them into SQL Server to use in our Web pages. We used DTS to transfer data.