General information
Category:
Windows API functions
>>I am looking to change a bunch of users from fox tables on a network to SQL databases in SQL Server. Is there a way to do this without going to every single machine and setting up the ODBC drivers? I think the windows API above will allow me to do this. Can I call this API within VFP 5.0 and use SQL Server without making changes on individual machines?
>>I already have the fox code running on several machines that do have the ODBC control panel set up.
>
>Ed,
>
>Try this:
>
>DECLARE INTEGER SQLConfigDataSource IN odbccp32.dll INTEGER, INTEGER, STRING, STRING
>
>lcType = 'SQL Server'
>lcODBC = 'DSN=' + ALLTRIM( tcDSN) + CHR(0) + ;
> 'Server=' + ALLTRIM( tcPath) + CHR(0) + ;
> 'Database=' + ALLTRIM( tcDatabase) + CHR(0) + ;
> 'Description=' + ALLTRIM( tcDSN)
>
>with tcDSN being the name of the data source, tcPath the name of the server, tcDatabase the name of the database and tcDSN a description
>
>You need to delete the data source first and then re-add - in case it changes for example and to ensure it is correct each time
>
>*-- delete it
>SQLConfigDataSource( 0, 3, lcType, lcODBC)
>*-- Add it
>SQLConfigDataSource( 0, 1, lcType, lcODBC)
>
>If it returns 0, then an error happened.
>
>HTH
Thanks! from Florida (in flames)
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only