Importing FREE Visual FoxPro 9.0 tables into SQL

Hi everybody,

I originally posted in the wrong forum MSDN Thread

I'm trying to create (for test purposes) a package to load data from VFP table into SQL Server 64 bit. So far I can not figure out how to do it - I created DSN as outlined in Todd's blog, but I don't know what to do next.

Can someone please give me step by step instructions so I will know if it's possible or not? I was under impression it's not possible, but Todd's blog seems to suggest otherwise.

Thanks in advance.

Visual FoxPro 7.0 represents a significant improvement over version 6.0. There are many new features designed to support COM, XML, and Web Services. Now COM servers built with Visual FoxPro are more flexible and robust thanks to strong typing and the ability to implement interfaces from other type libraries. IDE features like the new object browser combine convenience and efficiency, and other language features such as event handlers and early binding to COM objects increase performance. Lastly, an enhanced session class plus several new XML functions make Visual FoxPro a great choice for Web application development.

Erik Moore

MSDN Magazine October 2001

I Am Continiously Getting Error For Following Line Of Code, It Work  Fine In Other Database

Am I Doing Any Mistake

if (sh3itno != "" && dpsh3no != "")
            {
                string queryy = "SELECT [CHEQNO] FROM [SH3MAST] WHERE (([CHEQDATE] = " + chqdate + ") AND ([FAVOUR] = " + favour + ") AND ([CHQTYPE] = " + ctype + ") AND ([TRSTN] = " + trstn + ") AND ([TRBANK] = " + trbank + ") AND ([SH3ITNO] = " + sh3itno + ") AND ([DPSH3NO] = " + dpsh3no + "))";
                OdbcCommand cmd3 = new OdbcCommand(queryy, connen1);
                connen1.Open();
                string chqno =cmd3.ExecuteScalar().ToString(); (Here Iam Getting Error)
                tbl.Rows[i]["cheque no"] = chqno;
                connen1.Close();
            }

Stack Trace: 


[OdbcException (0x80131937): ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]Function name is missing ).]
   System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +39
   System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, Strin

I am working on a project that I have inherited that was built in VS 2008 using C# . Originally done as a Wizard it is now being changed to a single page form. When I first started I was able to drag and drop the textboxes and other elements around but then I had to change the tables from HTML to ASP so I could create them dynamically. After doing so I cannot click on anything inside the table when working in VS. Is this normal functionality? I'm relatively new to VS, ASP and C#

I have a directory with 200+ txt files to import into SQL tables in a database. Each file name is the exact table name in the database(without the file extension, obviously). I am looping through each file with a for each loop and a variable is mapped and set in the source connection properties for the Expressions -> ConnectionString property, so each name will go into that variable without the file extensions, correct?  Now, I set the variable name to the table name in the destination for the table name under "Data Access Mode", but it is giving an error...do I have to assign variables to each part, (Connection String and Name)? Does anyone have a quick setup for this?

Thanks!

Hello,

I am new in SQL server world and I have a problem in handling the import of lot of records (~12*10^6 records) between two SQL Servers that are in different domains.

I started using DTS through the import facility and I don't see lot of traffic on the LAN, so this seems a good approach, but it takes more than 4 hours to copy the entire temporary table from source SQL to destination SQL.

So I was thinking to linked server, and using sp_addlinkedserver I can hook the remote server. Now I would like to know if performing the select with the OPENQUERY is a better approach or if I could use a better solution.

My problem is that I should find a way for automating this activity every night, so every solution should be schedulable through SQL jobs, is this correct?

Thanks for any suggestion and help

Moreno

I uninstalled VWD 2010 Express Beta2. Then installed latest Release(April 12th) via Web Platform Installer ...oh yes after installing XP Service Pack 3....

It all installed successfully and when I start the VWD 2010 express image comes up ....there is this fine text that says....

"For Evaluation Purpose Only"

"Use of this software should be limited to evaluation purpose only"

Being confused with that message I looked at Help->About VWD 2010 Express and right on top it says:

"29 days remaining"

So what's happening ????????? Did I install some wrong product... I don't think so...I used Web Platform Installer and yes it is "Visual Web Developer 2010 Express" and not a Professional Trial software.

With VWD 2008 it says "This product is licensed".

Anybody having any ideas...I am sure it is just some mistake (can I say it's a bug?)

I I have an ASP.Net web site I built using Visual Studio 2008.  I also have a SQL 2005 database I use with this web site.  I presently use MS SQL Server MManagement Studio Express to add / modify SQL tables, stored procedures, etc. 

But I want to now maintain my SQL datbase directly from my Visual Studo 2008 where I maintain my ASP,Net web site.  I have created a script from my QL DB that creates all my existing tables and stored procedures.  Can I somehow run this to create the necessary source files within VS 2008?

Bob