Invalid connection - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Old Forums

CLOSED - General SQL Server

Invalid connection

Author

Topic

ronin2307
Posting Yak Master

126 Posts

Posted - 2005-03-16 : 12:31:43

Hi,

I am new to SQL connections and I am stuck with this error message:

[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection.

what am I doing wrong?


Dim DS As DataSet
        Dim MyCommand As OleDb.OleDbDataAdapter
        Dim MyConnection As OleDb.OleDbConnection

        MyConnection = New OleDb.OleDbConnection( _
            "Provider=sqloledb;Data Source=V:\mssql2000\MSSQL\Data\DATA06_Data.mdf;Ini  tial Catalog=some_table;User Id=sa;Password=xxxxx;")
        ' Select the data from Sheet1 of the workbook.
        MyCommand = New OleDb.OleDbDataAdapter("select * from [some_table]", MyConnection)

        DS = New DataSet
        Try
            MyCommand.Fill(DS)
        Catch ex As Exception
            TextBox1.Text = ex.Message
        End Try
        MyConnection.Close()