EDN Admin
Well-known member
Ive just upgraded to VS 2010 Pro, using C# to fiddle with a database app. This question may have been asked in similar formats, but this case is strange.
The facts: Im trying to swap some old .DBF files into an SQL database so that I can upgrade it to support multiple users. Theres multiple DBF files, all used by an ancient technology program written in Clipper back in 89. For one module
of the program to work, it somehow requires around 30 separate databases. Im trying to merge them into separate tables on a single database. In another post, someone recommended using WAMP Server to convert the files to SQL format. That
actually worked (I think). I used PHPMyAdmin 3.3.9 to import the DBF files and export them as SQL files. The description Windows offers is "SQL Server Database Primary Data File". Visual Studio wont let me import this file for local testing.
I went through the menu, selected SQL Server Database file, found mine no prob. When I click "Test Connection" it tells me the server was not found or not accessible(error 26). Ive exported the tables I converted in every SQL compatibility option
WAMP offers, and it still does that. I dont have SQL Server installed on my machine save whatever mini-version came with VS. Is that the problem? Im hesitant to install that at this phase as Ihavent even finished building the db to put
in it, Im still obviously in the prototyping stage of this part of the endeavor. Am I missing some compatibility issue or something? Millions of thanks in advance! If you need more info just ask! <hr class="sig May the fleas of a thousand camels feast happily on the lower regions of your enemies. And may their arms be too short to scratch!
View the full article
The facts: Im trying to swap some old .DBF files into an SQL database so that I can upgrade it to support multiple users. Theres multiple DBF files, all used by an ancient technology program written in Clipper back in 89. For one module
of the program to work, it somehow requires around 30 separate databases. Im trying to merge them into separate tables on a single database. In another post, someone recommended using WAMP Server to convert the files to SQL format. That
actually worked (I think). I used PHPMyAdmin 3.3.9 to import the DBF files and export them as SQL files. The description Windows offers is "SQL Server Database Primary Data File". Visual Studio wont let me import this file for local testing.
I went through the menu, selected SQL Server Database file, found mine no prob. When I click "Test Connection" it tells me the server was not found or not accessible(error 26). Ive exported the tables I converted in every SQL compatibility option
WAMP offers, and it still does that. I dont have SQL Server installed on my machine save whatever mini-version came with VS. Is that the problem? Im hesitant to install that at this phase as Ihavent even finished building the db to put
in it, Im still obviously in the prototyping stage of this part of the endeavor. Am I missing some compatibility issue or something? Millions of thanks in advance! If you need more info just ask! <hr class="sig May the fleas of a thousand camels feast happily on the lower regions of your enemies. And may their arms be too short to scratch!
View the full article