Hi
I am working on a little project using the new VB.net 2005 I keep getting this error

"An error occur. Error Number: 5 Description: Format of the initialization string does not conform to specification starting at index 0. Source: System.Data"


"An error occured. Error Number: 91 Description: object reference not set an instance of an object. Source: MainApp"


Please i need your help.

Thanks

Judging by the fact that the namespace "system.data" generated the error you are having problems connecting to a database. In order for any of us to assist you further you will need to post the portion of the code that generated the error. Please remember to use the "#" button before pasting your code in as it will leave the code sample properly formatted.

Thanks!



Best Regards,
Earl Francis

I wanted to know where area of the code should post you because my codes is much.

thanks

Only the section of the code that is generating the error is needed. You are probably creating connection and command objects, so just paste that code as a reply.



Best Regards,
Earl Francis

Imports System.Data
Imports System.Data.SqlClient
Public Class clsDatabase
    Function PopulateDataSetTable(ByVal strConnection As String, ByVal strTableName As String, ByVal strSQLorStoredProc As String, ByVal blnStoredProcedure As Boolean, ByRef dsDataSet As DataSet) As DataSet

        Try
            Dim sqlConn As New SqlClient.SqlConnection(strConnection)
            sqlConn.Open()
            Dim adapterProducts As New SqlClient.SqlDataAdapter()
            adapterProducts.TableMappings.Add("Table", strTableName)
            Dim cmdTable As SqlClient.SqlCommand = New SqlClient.SqlCommand(strSQLorStoredProc, sqlConn)
            'run stored procedure or SQL statement accordingly
            If blnStoredProcedure Then
                cmdTable.CommandType = CommandType.StoredProcedure
            Else
                cmdTable.CommandType = CommandType.Text
            End If
            adapterProducts.SelectCommand = cmdTable
            'fill the data set with the table information as specified in
            'the stored procedure or from the results of the SQL statement
            adapterProducts.Fill(dsDataSet)
            sqlConn.Close()
            Return dsDataSet
        Catch
            'error handling goes here
            UnhandledExceptionHandler()
        End Try
    End Function



Public Class BaseSearchform
    Inherits System.Windows.Forms.Form

    Protected Const PROD = "Products"
    Protected Const SUPP = "Suppliers"
    Protected Const CONN = "user id="";password=; initial " & "catalog=NorthwindSQL;server=local"

    Protected dsData As DataSet
    Protected dsResults As DataSet
    Protected adapterResults As New SqlClient.SqlDataAdapter()


    'Sub UnhandledExeceptionHandler()
    ' MsgBox("An error occurred. Error Number: " & Err.Number & "Description: " & Err.Description & " Source:" & Err.Source)
    'End Sub

    Sub AddSearchMethod()
        Try
            If cboSearchMethod.Items.Count = 0 Then
                cboSearchMethod.Items.Add(PROD)
                cboSearchMethod.Items.Add(SUPP)
            End If
        Catch ex As Exception
            UnhandledExceptionHandler()
        End Try
    End Sub

I was able to duplicate your error in a test environment on my computer.

It looks like you need to designate a user and a password in your connection string.

You have:

Protected Const CONN = "user id="";password=; initial " & "catalog=NorthwindSQL;server=local"

It should read:

Protected Const CONN = "user id=" & YourUserNameHere & ";password=" & YourPassWordHere & "; initial " & "catalog=NorthwindSQL;server=local"

You need to either hard code a user and a password (not generally a good idea from a security standpoint), or present a login screen and get the information that way.

I hope this helps, and good luck!



Best Regards,
Earl Francis

Thanks but i used windows authenication to login to my sql server. i dont use a password and the username field is always blank.

Please can you kindly tell me how i can put it.
thanks

To use Windows authentication in your connection string, replace the "user id=xx;password=xx" part with "Integrated Security=SSPI;"

Example:
Protected Const CONN = "Integrated Security=SSPI; initial " & "catalog=NorthwindSQL;server=local"






Best Regards,
Earl Francis

Thanks a lot but i just got this recent error.

"An error occured. Error Number: 5 Description: An error has occurred while establishing a connection to the server. When connectiong to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider:Name Pipes Provider, error 40- Could not open a connection to SQL Server) Source:.net SqlClient Data Provider"

This is how i did my connection i don't know whether that is the cause.

"Protected Const CONN = "Integrated Security=SSPI; initial " & "catalog=NorthwindSQL;server=local" & "user id=xx;password=xx;"

Also i am not using SQL2005 i am using SQL2000.

thanks

thats

Are NamedPipes and TCP/IP connections (remote connections) allowed on the server you are attempting to connect to?

Make sure they are, then everything should work fine. (I've been dealing with this one a bunch!)

Karen