At home this works and I Upsized about 2GB of data with no problems. At the office i tried the same but cannot see the database I have in SQl server
all I see is crss and mquis which seem to be default database in sql server.
I had gone ti the server and manually created the vCPR database.
Peter


>Haven't tried TCP-IP in an NT platform. Maybe because MS heavily endorsed NAMED PIPES. We'll look into this further.
>
>>I have found Named Pipes to be slow. And then there is the extra problem with having to go through a router to get to the server hasn't worked much for me. Probably because the firewalls are not letting in that protocol.
>>
>>Bring up the Client Network Utility. You should be able to find it under the SQL Server section of the menu. If not, look on your system for the file CLICONFG.EXE. Click on Add and fill in the appropriate information. I suggest using TCPIP but the choice is yours.
>>
>>>Can you access the SERVER through Network Neighborhood? Also, try to make sure that you are using NAMED PIPES when accessing SQL Server in an NT platform.
>>>
>>>>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.