SQL Connectivity

Hot Topic

Win 2003 x64 - SSIS error Importing xls and access data
how can I add a unique key column to a table and generate its values automatically?
Uninstall Microsoft SQL 2005 CTP
Transformation script last row
Standard Classes not understood in report server
need help on a query--sequence number
SUM problem in SSRS 2005 report
How to search all columns in a table at once?
Is it possible to deploy reports on server and view it from client machines
A question on Conversation timer persistence

SQL Server

cmdexec subsystem failure
Convert MMYY ?
Look up transformation
How to stop a package
Merge Replication Questions [SQL2k5 non express]
Multiple transactions not working in package
Reporting Services Parameters
Replicacion Merge SQL Server 2005 Express Edition
auto uncheck the table permit
Migrating SSIS Packages to Production and Job Scheduling

SQL Connectivity

I am building a C# Windows app.  I have a form and have also create a db.  I tested the db connectivity in Server Explorer and the test came back successfully.  According to my manual, I just need to drag the db item from the server explorer to my form designer to creation the connection.  When I do this nothing happens... what am I doing wrong

If I do the same thing in VS2003 the sqlConnection1 shows up, how do I accomplish the same thing with 2005



Answer this question

SQL Connectivity

  • perfect_alcon

    There could be a few things wrong, but I suggest that you check the second thing first - make sure you have the SQL2K5 client software installed. You can find that on your SQL2K5 CD.

    Although it refers to something called SMO, you can check out this article for a step-by-step explanation on the process of using C# and SQL.

    http://www.codeproject.com/useritems/SMODemo.asp

    Carpe Datum



  • SQL Connectivity
Answer this question