Error when using odbc data adapter wizard in VS.Net

[Dermot O'Loughlin]

Can anyone help me with this?

I get the following error when using the odbc adapter wizard in VS.Net
2003:

---------------------------
Wizard Form
---------------------------
An unexpected error has occurred.

Error Message: [S1110] [Microsoft][ODBC Driver Manager] Only
SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled

Call Stack: at Microsoft.VSDesigner.Data.VS.OdbcUtil.GetBackendNa meOdbc(IntPtr
parentHandle, ConnectionString connectString, String& backendName)

at Microsoft.VSDesigner.Data.VS.VsConnectionManager.C heckConnection(Int32
index, ProviderNameInfo nameInfo)

at Microsoft.VSDesigner.Data.VS.VsConnectionManager.G etConnectionNameList(ArrayList
nameList, ProviderNameInfo nameInfo)

at Microsoft.VSDesigner.Data.VS.ConnectionPage.InitIn put()

at Microsoft.VSDesigner.Data.VS.ConnectionPage.OnEnte rPage(EventArgs
e)

at Microsoft.VSWizards.WizardPage.RaiseEnterPage()

at Microsoft.VSWizards.WizardForm.NextPage()

at Microsoft.VSWizards.WizardForm.Next_Click(Object sender,
EventArgs e)
---------------------------
OK
---------------------------

[Paul Sellars]

Hello,

I, too, have the same problem. I'm using Visual Studio.net 2003.
Can any one help, please?

Thanks,
Paul

"Dermot O'Loughlin" wrote:

Can anyone help me with this?

I get the following error when using the odbc adapter wizard in VS.Net
2003:

---------------------------
Wizard Form
---------------------------
An unexpected error has occurred.

Error Message: [S1110] [Microsoft][ODBC Driver Manager] Only
SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled

Call Stack: at Microsoft.VSDesigner.Data.VS.OdbcUtil.GetBackendNa meOdbc(IntPtr
parentHandle, ConnectionString connectString, String& backendName)

at Microsoft.VSDesigner.Data.VS.VsConnectionManager.C heckConnection(Int32
index, ProviderNameInfo nameInfo)

at Microsoft.VSDesigner.Data.VS.VsConnectionManager.G etConnectionNameList(ArrayList
nameList, ProviderNameInfo nameInfo)

at Microsoft.VSDesigner.Data.VS.ConnectionPage.InitIn put()

at Microsoft.VSDesigner.Data.VS.ConnectionPage.OnEnte rPage(EventArgs
e)

at Microsoft.VSWizards.WizardPage.RaiseEnterPage()

at Microsoft.VSWizards.WizardForm.NextPage()

at Microsoft.VSWizards.WizardForm.Next_Click(Object sender,
EventArgs e)
---------------------------
OK
---------------------------