SQL local server db connection

microsoft.public.sqlserver.programming

20 May 2006 3:22 PM

ddevans888

I have found lots of information on my SQL connection but none of it is
helping. I am just learning and I am using Dreamweaver MX. I can see
my tables in DW but when I try to run my page I keep getting these
messages. I am working on my local PC with my SQL db connection on my
local PC. I can run pages using ColdFusion but not with my SQL db
connection. Can anyone advise me? The errors I'm getting are below.
I don't understand why I can connect to the tables and use them in DW
to design but they won't run in my browser.
Thanks for looking.
Nordite

System.ArgumentException: The .Net Framework Data Provider for OLEDB
(System.Data.OleDb) does not support the Microsoft OLE DB Provider for
ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
(System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String
progid)
at
System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String
connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(String
connectionString, Boolean validate)
at
System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String
connectionString, DbConnectionOptions previous)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at
System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)

at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)

at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()
System.Exception: The DefaultView was requested but no tables yet
exist.
at DreamweaverCtrls.DataSet.get_DefaultView()

20 May 2006 4:39 PM

Mike C#

Without seeing some code it's hard to tell. It looks like you *might* be
trying to connect to your SQL Server using OLEDB but passing it a connection
string that specifies an ODBC driver.

<ddevans***@yahoo.com> wrote in message
Show quote

news:1148138528.047474.308940@i39g2000cwa.googlegroups.com...
>I have found lots of information on my SQL connection but none of it is
> helping. I am just learning and I am using Dreamweaver MX. I can see
> my tables in DW but when I try to run my page I keep getting these
> messages. I am working on my local PC with my SQL db connection on my
> local PC. I can run pages using ColdFusion but not with my SQL db
> connection. Can anyone advise me? The errors I'm getting are below.
> I don't understand why I can connect to the tables and use them in DW
> to design but they won't run in my browser.
> Thanks for looking.
> Nordite
>
>
> System.ArgumentException: The .Net Framework Data Provider for OLEDB
> (System.Data.OleDb) does not support the Microsoft OLE DB Provider for
> ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
> (System.Data.Odbc).
> at System.Data.OleDb.OleDbConnectionString.ValidateProvider(String
> progid)
> at
> System.Data.OleDb.OleDbConnectionString.ValidateConnectionString(String
> connectionString)
> at System.Data.OleDb.OleDbConnectionString..ctor(String
> connectionString, Boolean validate)
> at
> System.Data.OleDb.OleDbConnectionFactory.CreateConnectionOptions(String
> connectionString, DbConnectionOptions previous)
> at
> System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String
> connectionString, DbConnectionPoolGroupOptions poolOptions,
> DbConnectionOptions& userConnectionOptions)
> at
> System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String
> connectionString, DbConnectionPoolGroupOptions poolOptions,
> DbConnectionOptions& userConnectionOptions)
> at System.Data.OleDb.OleDbConnection.ConnectionString_Set(String value)
>
> at System.Data.OleDb.OleDbConnection.set_ConnectionString(String value)
>
> at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
> at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
> at DreamweaverCtrls.DataSet.DoInit()
> System.Exception: The DefaultView was requested but no tables yet
> exist.
> at DreamweaverCtrls.DataSet.get_DefaultView()
>

20 May 2006 7:50 PM

Erland Sommarskog

(ddevans***@yahoo.com) writes:

> I have found lots of information on my SQL connection but none of it is
> helping. I am just learning and I am using Dreamweaver MX. I can see
> my tables in DW but when I try to run my page I keep getting these
> messages. I am working on my local PC with my SQL db connection on my
> local PC. I can run pages using ColdFusion but not with my SQL db
> connection. Can anyone advise me? The errors I'm getting are below.
> I don't understand why I can connect to the tables and use them in DW
> to design but they won't run in my browser.

The error message indicates that you are trying to use the MSDASQL
provider with the OleDB .Net Data Provider which is not possible.

Since it works in Dreamweaver MX, this would imply that you are using
two different environments, which probably is not a good idea.

Since I don't know Dreamweaver MX, it's difficult to give exact advice.
But you should change your connection string, so that it does not
include Driver=, but instead add Provider=SQLOLEDB.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx