Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> Visual Basic >> Visual Basic General

Add connection wizard fails with Access database

I have the RTM version installed. I am quite puzzled at this wizard. It works fine with SqlClient. But for Access databases, this wizard completely fails.

In this wizard, I only have one option to do - setting the ConnectionString. I set it to Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\path\abc.mdb, which works fine in my code. But when I click OK, it complains:
Microsoft Visual Studio

Format of the initialization string does not conform to specification starting at index 0.

OK
And more, the Advanced button is disabled and the dialog does have the same funtionalities as described in MSDN ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vdt01/html/a7df4f53-2a58-4e03-8326-cb578e61f1a7.htm.

Bug?

[734 byte] By [Neo] at [2007-12-24]
«« Custom check-in policy
»» Binding Mode=Onetime
# 1
I got the same problem when trying to use access database connection. I am currently using VWD 2005 express edition for my website. The connection string in web.config is as follow:

<connectionStrings>

<add name="AccessFileName" connectionString="~/App_Data/ASPNetDB.mdb" providerName="System.Data.OleDb"/>

<add name="facility" connectionString="~/App_Data/facility.mdb;" providerName="System.Data.OleDb" />

</connectionStrings>

when running the application, give me the message
"Format of the initialization string does not conform to specification starting at index 0."

I looked online. This is supposed to be a bug in .NET 1.1 for Microsoft SQL Server .NET Data Provider (SqlClient), was fixed. http://support.microsoft.com/?kbid=823679

Weird thing is the first connection which takes care of the membership and roles works ok, only the second connection to "facility" returns the error.

linch12 at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 2

I'm experiencing the same problem.

lynch12,

You said the first database worked in VB? I'm not sure if it makes a difference, but you have a semicolon at the end of your connectionString inside the quotes.

seandop at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 3
Did you ever figure this out? I've been having the same problem with this and other dispositions. I'm also using VWD Express. It works on one of my machines but not on the other. When I try to add an Access DB in the DB Explorer, I do not get the correct screen for the Access DB. Instead, I see a generic Add Connection box that displays a blank ConnectionString property. If I add anything (even gargage) to the CS property and click Test Connection, it returns with a Test Connection Succeeded which I know is bogus. I've tried completely uninstalling and reinstalling Office 2003 and VWD and checking MDAC and Jet installations. Nothing has worked. It's got to be something simple. I seem to be the only person in the world having this problem.

Thanks.

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 4

Hi Neo,

It sounds like there is a problem with VS setup -- specifically registration of the data provider.

Can you try reinstalling VS?

Thanks.

Milind Lele
PM, VS Data

MilindLele-MSFT at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 5
Thanks Milind,

I've tried uninstalling and reinstalling. I'm suspect though that I didn't ever get a clean uninstall of beta versions even though I ended up using manual uninstalls and the beta uninstall tool (vs_uninst_betas.exe). I think I need more info on where to look for incorrect files and registry values etc.

Gerry

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 6

Hi Gerry,

You suspision seems valid. The only thing I can think of is to get your reg hive for the data provider.

Can you send me the subtrees under:

HKLM\Software\Microsoft\VisualStudio\8.0\DataProviders and
HKLM\Software\Microsoft\VisualStudio\8.0\DataSources

I hope that can give us some clue.

Thanks.

Milind

MilindLele-MSFT at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 7
Hi Milind,

There were no DataSource or DataProvider entries under VisualStudio, only under VWDExpress. These entries are below but they look the same as those on a working machine.

Thanks.

Gerry

DataSources:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{067EA0D9-BA62-43f7-9106-34930C60C528}]
@="Microsoft SQL Server"
"DefaultProvider"="{91510608-8809-4020-8897-FBA057E22D54}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{067EA0D9-BA62-43f7-9106-34930C60C528}\SupportingProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{067EA0D9-BA62-43f7-9106-34930C60C528}\SupportingProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]
"Description"="DataProvider_OleDB_SqlDataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"SpecializedProvider"="SQLOLEDB.1"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{067EA0D9-BA62-43f7-9106-34930C60C528}\SupportingProviders\{91510608-8809-4020-8897-FBA057E22D54}]
"DisplayName"="DataSource_MicrosoftSqlServer, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Sql_DataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{42568F9E-354A-4c76-9916-3225D8C8E750}]
@="ODBC Data Source"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{42568F9E-354A-4c76-9916-3225D8C8E750}\SupportingProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{42568F9E-354A-4c76-9916-3225D8C8E750}\SupportingProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}]
"DisplayName"="DataSource_MicrosoftOdbcDsn, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Odbc_DataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{466CE797-67A4-4495-B75C-A3FD282E7FC3}]
@="Microsoft Access Database File"
"DefaultProvider"="{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{466CE797-67A4-4495-B75C-A3FD282E7FC3}\SupportingProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{466CE797-67A4-4495-B75C-A3FD282E7FC3}\SupportingProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]
"DisplayName"="DataSource_MicrosoftAccess, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_OleDB_AccessDataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"SpecializedProvider"="Microsoft.Jet.OLEDB.4.0"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{485C80D5-BC85-46db-9E6D-4238A0AD7B6B}]
@="Microsoft SQL Server Database File"
"DefaultProvider"="{91510608-8809-4020-8897-FBA057E22D54}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{485C80D5-BC85-46db-9E6D-4238A0AD7B6B}\SupportingProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{485C80D5-BC85-46db-9E6D-4238A0AD7B6B}\SupportingProviders\{91510608-8809-4020-8897-FBA057E22D54}]
"DisplayName"="DataSource_MicrosoftSqlServerFile, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Sql_FileDataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{E5E86CD6-6454-4fdd-910F-DC5DFC73EB45}]
@="Oracle Database"
"DefaultProvider"="{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{E5E86CD6-6454-4fdd-910F-DC5DFC73EB45}\SupportingProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{E5E86CD6-6454-4fdd-910F-DC5DFC73EB45}\SupportingProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]
"Description"="DataProvider_OleDB_OracleDataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"SpecializedProvider"="MSDAORA.1"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataSources\{E5E86CD6-6454-4fdd-910F-DC5DFC73EB45}\SupportingProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}]
"DisplayName"="DataSource_Oracle, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Oracle_DataSource_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

DataProviders:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}]
@=".NET Framework Data Provider for OLE DB"
"DisplayName"="DataProvider_OleDB, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"ShortDisplayName"="DataProvider_OleDB_Short, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_OleDB_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
"FactoryService"="{8CB5F787-2D74-459e-88D6-39E20A4D9454}"
"InvariantName"="System.Data.OleDb"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0]
"DataSource"="{466CE797-67A4-4495-B75C-A3FD282E7FC3}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0\DataConnectionPromptDialog]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBJetConnectionPromptDialog, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0\DataConnectionProperties]
@="Microsoft.Data.ConnectionUI.OleDBAccessConnectionProperties, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0\DataConnectionUIControl]
@="Microsoft.Data.ConnectionUI.AccessConnectionUIControl, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0\DataSourceInformation]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBJetDataSourceInformation, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\Microsoft.Jet.OLEDB.4.0\DataViewSupport]
@="OleDBJetDataViewSupport"
"Assembly"="Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\MSDAORA.1]
"DataSource"="{E5E86CD6-6454-4fdd-910F-DC5DFC73EB45}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\MSDAORA.1\DataConnectionProperties]
@="Microsoft.Data.ConnectionUI.OleDBOracleConnectionProperties, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\MSDAORA.1\DataConnectionUIControl]
@="Microsoft.Data.ConnectionUI.OracleConnectionUIControl, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\MSDAORA.1\DataSourceInformation]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBOracleDataSourceInformation, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\MSDAORA.1\DataViewSupport]
@="OleDBOracleDataViewSupport"
"Assembly"="Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLNCLI.1]
"DataSource"="{067EA0D9-BA62-43f7-9106-34930C60C528}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLNCLI.1\DataConnectionProperties]
@="Microsoft.Data.ConnectionUI.OleDBSqlConnectionProperties, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLNCLI.1\DataConnectionUIControl]
@="Microsoft.Data.ConnectionUI.SqlConnectionUIControl, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLNCLI.1\DataSourceInformation]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBSqlDataSourceInformation, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLNCLI.1\DataViewSupport]
@="OleDBSqlDataViewSupport"
"Assembly"="Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLOLEDB.1]
"DataSource"="{067EA0D9-BA62-43f7-9106-34930C60C528}"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLOLEDB.1\DataConnectionProperties]
@="Microsoft.Data.ConnectionUI.OleDBSqlConnectionProperties, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLOLEDB.1\DataConnectionUIControl]
@="Microsoft.Data.ConnectionUI.SqlConnectionUIControl, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLOLEDB.1\DataSourceInformation]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBSqlDataSourceInformation, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\SQLOLEDB.1\DataViewSupport]
@="OleDBSqlDataViewSupport"
"Assembly"="Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\VFPOLEDB.1]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\Specialization\VFPOLEDB.1\DataSourceInformation]
@="Microsoft.VisualStudio.DataTools.Providers.OleDB.OleDBFoxDataSourceInformation, Microsoft.VisualStudio.DataTools, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionPromptDialog]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionPromptDialog\{466CE797-67A4-4495-B75C-A3FD282E7FC3}]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionProperties]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataConnectionUIControl]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataObjectSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataSourceSpecializer]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{7F041D59-D76A-44ed-9AA2-FBF6B0548B80}\SupportedObjects\DataViewSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}]
@=".NET Framework Data Provider for Oracle"
"DisplayName"="DataProvider_Oracle, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"ShortDisplayName"="DataProvider_Oracle_Short, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Oracle_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
"FactoryService"="{F638BEE1-DC22-4401-8A4A-6DB0B13C196C}"
"InvariantName"="System.Data.OracleClient"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataConnectionPromptDialog]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataConnectionProperties]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataConnectionSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataConnectionUIControl]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataObjectSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataSourceSpecializer]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{8F5C5018-AE09-42cf-B2CC-2CCCC7CFC2BB}\SupportedObjects\DataViewSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}]
@=".NET Framework Data Provider for SQL Server"
"DisplayName"="DataProvider_Sql, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"ShortDisplayName"="DataProvider_Sql_Short, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Sql_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
"FactoryService"="{FCD3F3E8-69AC-42d5-905E-2E131905E708}"
"InvariantName"="System.Data.SqlClient"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataConnectionPromptDialog]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataConnectionProperties]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataConnectionSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataConnectionUIControl]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataObjectSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataSourceSpecializer]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{91510608-8809-4020-8897-FBA057E22D54}\SupportedObjects\DataViewSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}]
@=".NET Framework Data Provider for ODBC"
"DisplayName"="DataProvider_Odbc, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"ShortDisplayName"="DataProvider_Odbc_Short, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Description"="DataProvider_Odbc_Description, SR, Microsoft.Data.ConnectionUI.Dialog, Version=8.0.0.0, Culture=Neutral, PublicKeyToken=b03f5f7f11d50a3a"
"Technology"="{77AB9A9D-78B9-4ba7-91AC-873F5338F1D2}"
"FactoryService"="{06D0BE35-FA3A-4ef6-81B9-3EDBB68EF982}"
"InvariantName"="System.Data.Odbc"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataConnectionPromptDialog]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataConnectionProperties]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataConnectionSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataConnectionUIControl]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataObjectSupport]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataSourceSpecializer]
@=""

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\VWDExpress\8.0\DataProviders\{C3D4F4CE-2C48-4381-B4D6-34FA50C51C86}\SupportedObjects\DataViewSupport]
@=""

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 8

Hi Gerry,

Thanks for sending us the registry dump. You are right, everything there looks correct. The only remaining registration issue to check is that the ADO .NET providers are correctly installed on the machine. To verify this, locate your .NET Framework directory under the windows directory (typically windows\Microsoft .NET\Framework\v2.0.50727) and look in the config directory. There should be a machine.config file in here. Please send me the contents of the <system.data> section of this XML file.

Thanks,
Stephen

StephenProvine at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 9
Hey Stephen,

<system.data> is below.

Thanks.

 <system.data>
<DbProviderFactories>
<add name="Odbc Data Provider" invariant="System.Data.Odbc" description=".Net Framework Data Provider for Odbc" type="System.Data.Odbc.OdbcFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OleDb Data Provider" invariant="System.Data.OleDb" description=".Net Framework Data Provider for OleDb" type="System.Data.OleDb.OleDbFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="OracleClient Data Provider" invariant="System.Data.OracleClient" description=".Net Framework Data Provider for Oracle" type="System.Data.OracleClient.OracleClientFactory, System.Data.OracleClient, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
<add name="SqlClient Data Provider" invariant="System.Data.SqlClient" description=".Net Framework Data Provider for SqlServer" type="System.Data.SqlClient.SqlClientFactory, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/>
</DbProviderFactories>
</system.data>

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 10

Ok, this all looks fine too. I am running out of ideas here. Is there a way you can attach a debugger to your VWExpress.exe and before reproducing the problem, tell it to break on common language runtime exceptions? This will identify exactly what the issue is.

Thanks,
Stephen

StephenProvine at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 11
Stephen,

I'm not sure if I'm doing this correctly b/c VWD is not throwing an error that
appears in the debugger. What I have done is run the Microsoft CLR Debugger and
attached to VWDExpress.exe. I've tried a couple of different ways which I think
will accomplish the same thing, that is, I've selected "Program to Debug" from
the "Debug" menu and launched VWDExpress.exe from there. I've also started VWDExpress.exe
then attached to the process from within the debugger. I've tried setting the
Common Language Runtime Exceptions the break when an exception is "Thrown", "
User-unhandled" and all combinations of the two.

I have tried hand coding the SQL and running the query against the (Access)
db and get probably the most detailed info from w/in VWD, and that is: "Could
not create connection Object reference not set to an instance of an object."
But, I do not receive any exception information in the CLR debugger.

I can copy this project over to another machine and it works fine. In fact, the
other machine automatically sees the Access db under my App_Data folder (
Database Explorer view) w/o me adding it explicitly. I assume that this is
in fact what should happen. The problem machine has never done this.

The problem in a nutshell seems that I am not able to connect to an Access DB.
(I can connect through an ODBC alias)

I'm absolutely stimied.

Gerry

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 12

Gerry,

Is there any setting in the Microsoft CLR Debugger for debugging "just my code"? If so, and this is checked, uncheck it. This might help in catching the exception.

When you hand coded the SQL and run the query against the DB, what were you using to do this? The query designer or a script editor or something else? Where exactly does the error message show up?

Thanks,
Stephen

StephenProvine at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 13
Stephen,

Unchecking "just my code" worked.

I have tried both using the script editor and the query builder in order to
test the SQL. However, using the wizard only, I never get that far so I think
it's a connection issue rather and anything having to do with the SQL.
The error/problem has several dispositions depending on what exactly I attempt. I assume
that these dispositions relate to the same root problem.

Disposition 1:
There is a AccessFileName.mdb in the App_Data folder. I have tested this file
on the other machine as well as make sure that it works in Access. The file
appears to be ok.

Using the Database Explorer, I attempt an "Add Connection".
An "Add Connection" Window opens defaulted to a MS ODBC Data Source. (on the working machine, a "Choose Data Source"
window opens). I select "Change" and the "Choose Data Source"
window opens. I select "Microsoft Access Database File" and click "OK". An "
Add Connection" window opens that is generic (working machine "Add Connection"
window is specific for MSAccess file).
Also, the following error(s) appears in the CLR debugger:
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll

Disposition 2:
An AccessDataSource is added to a Webform. I select "Configure Data Source"
from the smart tag drop down list. I browse to the .mdb in the App_Data folder
and click next. The "How would you like to retrieve data from you database?"
screen is skipped and a "Define Custom Statements or Stored Procedure" window
opens with "Select, Update" etc tabs. Also, the following error(s) appears in the
CLR debugger:
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll

If I click on "Query Builder" an error window displays in VS "Object reference
not set to an instance of an object." Also, the following error(s) occur in
the CLR debugger:
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll
A first chance exception of type 'System.NullReferenceException' occurred in Microsoft.VisualStudio.DataTools.dll

Hope this gives you some more info.

Thanks.
Gerry

GPolk at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
# 14

Gerry,

We're getting closer. If you can run the same scenario again under the debugger, particular between choosing a data source and seeing a generic Add Connection window, and for any one of these exceptions capture the call stack and attach that, it will help me isolate the problem. I am beginning to think that the Access OLE DB provider is not properly registered on the machine.

Thanks,
Stephen

StephenProvine at 2007-8-31 > top of Msdn Tech,Visual Basic,Visual Basic General...
Visual Basic
Visual Basic General

Visual Basic Hot Topic

Visual Basic New Topic

Visual Basic

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified