Can I connect to my SQL Server 2000 with VS Express

Hot Topic

Simple .bat example
Disabled control not shaded
(newbie) How to refresh text box contents
DataAdapter Update Error :Syntax error in INSERT INTO statement
how to update the GUI from a different class
Let's go to work on an FAQ for this Forum
WH_KEYBOARD_LL
Manual Installation without Optional content...
Loop through numericUpDown controls
How do you insert a byte in a string (without expansion)?

VS Express Editions

Parenting a form?
dumb newcomer question
How do I calculate a person's age?
(newbie) Simple array - complex problem
Help me!!!
Problem porting a Visual C++ 6 application to Visual C++ 2005
web.config AppSettings
Error: undeclared identifier
Visual Studio 2005 = very unstable !!!
Unable to register from website...

Can I connect to my SQL Server 2000 with VS Express

I seem to be having a difficult time connecting to my local SQL Server 2000 from VS 2005 Express.

Can it be done

If not, is there a way to import a table from SS2000 somehow

Thanks.

Answer this question

Can I connect to my SQL Server 2000 with VS Express

  • Dennis Tap

    Yes, I have been using the wizard, and it just can't find any (local) SQL Servers.

    What I'll do is try it in code and see what happens.

    I think I'm just spinning my wheels using the Express version. Ever since it came out I've been having difficulty doing anything with SQL Server. When you try to jump ahead of the process with these Beta and limited versions it becomes more of a pain than a good experience.

    In a few days the full version should be available to us in the stores and on line and I can then order it and have something real to work with.

    Thanks.

    CU

  • Anil John

    How are you trying to connect to the SQL 2000 databse, the Express IDE's wizards are not able to connect to the database and you will have to configure the connection manualy and in code.

  • gavrilenko_s

    If SQL 2000 is on the same machine as VWD Express you should be able to connect.  I think remote access to servers is not supported.  You would need Standard or above for that.

  • Can I connect to my SQL Server 2000 with VS Express
Answer this question