That's what I am trying to do.
But I get the following message:
Connection Failed
SQL state:'01000'
SQL server error: 161
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen [createFile())
Connection failed:
SQL state: '08001'
SQL server Error: 161
[Microsoft][ODBC SQL Server DriverClient Unable to establish connection
Now what?
Peter
>>I need to upsize one of my apps to SQL server.
>>I have SQLServer7 installed on one of our servers (BDC2) and created a database called vCPR.
>>When I go into VFP on my workstation (Win98SE)and open the database and run the upsizing wizard it asks for a database to upsize to. How can I make this sql db visible in the wizard.
>>I had done that in the past as a test with a local sql install and it worked. Now I need to go live.
>>
>>Any help is appreciated.
>
>Establish the connection of the data source you will be using. Go to the Control Panel and invoke 32bitODBC icon. Choose System DSN and specify the Server where your SQL Server was installed.
Peter Cortiel