Data source name not found and no default driver specified - When the website was publishe

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.Odbc.OdbcException: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[OdbcException (0x80131937): ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified] System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +35 System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +131 System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +98 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.Odbc.OdbcConnection.Open() +37 DBConnection.open() +12 ASP.global_asax.Session_Start(Object sender, EventArgs e) +35 System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) +2163182 System.Web.SessionState.SessionStateModule.CompleteAcquireState() +154 System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) +542 System.Web.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +90 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +155

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

ODBC version 3.526.1830.0
strconn ="DSN=testserver;uid=tester;pwd=tester;DATABASE=Test_Database"

I've Test_Database on 2 machines (same data in both machines), one is in SQL 2005 server and another one is in SQL 2000 server.
When the website was published, it can't work. (with both database). But it work in debug mode in Visual Studio2005.

The website can't work when use ODBC connection but it work when use SqlClient.

Help me solve this problem please. T_T

Thanks in advance,

Did you create the ODBC DSN in your local machine?|||Yes sir , I've use ODBC while I develop this website. It can run in debug mode sir !|||

Ok, just let me know if you are getting this error on localhost or on a hosting server?

Also don't call me Sir

|||

I get this error nn localhost.

Database is on localhost(SQL2005) and other one is on another machine(SQL2000).

|||

Ok, check

www.connectionstrings.com

And make sure your connectionstring is correct.

Regards

|||

Yeah , It's resolved.

I added wrong DSN. I added it in User DSN. T_T

So I add new DSN in File DSN and the website work.

Thanks for your advice,

Regards,

|||

buabanz:

So I add new DSN in File DSN and the website work.

Oh sorry, I've added it in System DSN.

sql

Data source name not found and no default driver specified

I know this may be a simple problem, but here it is:

I have SQL server express installed on Windows 2003 server (Testing) it works fine;

When I move it to my production server (Windows 2003) I get the error message"Data source name not found and no default driver specified "

The system DSN in ODBC connections works fine, or at least completes the test ok.

My application is written in Classic ASP

PLEASE HELP

Thanks

Can you provide your connection string?|||"Driver={SQL Server};Server=localhost;Database=TEST;Uid=MyUser;Pwd=MyPass;"

Data source name not found and no default driver specified

I know this may be a simple problem, but here it is:

I have SQL server express installed on Windows 2003 server (Testing) it works fine;

When I move it to my production server (Windows 2003) I get the error message"Data source name not found and no default driver specified "

The system DSN in ODBC connections works fine, or at least completes the test ok.

My application is written in Classic ASP

PLEASE HELP

Thanks

Can you provide your connection string?|||"Driver={SQL Server};Server=localhost;Database=TEST;Uid=MyUser;Pwd=MyPass;"

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down box
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolve
Hmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/d...displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>

Data source name not found and no default driver specified

Data source name not found and no default driver specified
This is the error I get when attempting to install my copy of SQL Server
2000 developer edition.
I had SQL Server installed on my workstation, functioning correctly. My
computer crashed and it appears that there is some sort of registry
corruption because I could not open up my local instance in Enterprise
Manager.
Checking ODBCAD32, it did not appear that I had any drivers installed for
any source (MS Access, standard ODBC, SQL Server, etc.)
I attempted to execute the MDAC on the Microsoft web site with no results.
The component Checker determined that I had MDAC 2.8 SP1 on Windows XP SP2.
I uninstalled and reinstalled SQL Server and on the final step, the above
message appeared.
How do I get the default SQL Server driver reinstalled to my workstation. My
network techs indicate that I have to reinstall my OS to get the drivers
back. This seems a little extreme.
Thank you in advance.
Any joy there ? I was demoing a client install of SQL 2000 when I
canceled it and "poof" all my ODBC drivers disappeared.
I had previously installed and removed SQL 2005 Beta, so the only option
I had was to re-install connectivity to SQL 2005 and use "SQL Native
Client"
It looks like a re-build.
I've seen a few posts like this but never any response.
yay.
In article <u8fOB7fFFHA.4016@.TK2MSFTNGP09.phx.gbl>,
sxcostanzo@.hotmail.com says...
> Data source name not found and no default driver specified
> This is the error I get when attempting to install my copy of SQL Server
> 2000 developer edition.
> I had SQL Server installed on my workstation, functioning correctly. My
> computer crashed and it appears that there is some sort of registry
> corruption because I could not open up my local instance in Enterprise
> Manager.
> Checking ODBCAD32, it did not appear that I had any drivers installed for
> any source (MS Access, standard ODBC, SQL Server, etc.)
> I attempted to execute the MDAC on the Microsoft web site with no results.
> The component Checker determined that I had MDAC 2.8 SP1 on Windows XP SP2.
> I uninstalled and reinstalled SQL Server and on the final step, the above
> message appeared.
> How do I get the default SQL Server driver reinstalled to my workstation. My
> network techs indicate that I have to reinstall my OS to get the drivers
> back. This seems a little extreme.
> Thank you in advance.
>
>

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down box
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolveHmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>sql

Data source name not found and no default driver specified

Data source name not found and no default driver specified
This is the error I get when attempting to install my copy of SQL Server
2000 developer edition.
I had SQL Server installed on my workstation, functioning correctly. My
computer crashed and it appears that there is some sort of registry
corruption because I could not open up my local instance in Enterprise
Manager.
Checking ODBCAD32, it did not appear that I had any drivers installed for
any source (MS Access, standard ODBC, SQL Server, etc.)
I attempted to execute the MDAC on the Microsoft web site with no results.
The component Checker determined that I had MDAC 2.8 SP1 on Windows XP SP2.
I uninstalled and reinstalled SQL Server and on the final step, the above
message appeared.
How do I get the default SQL Server driver reinstalled to my workstation. My
network techs indicate that I have to reinstall my OS to get the drivers
back. This seems a little extreme.
Thank you in advance.Any joy there ? I was demoing a client install of SQL 2000 when I
canceled it and "poof" all my ODBC drivers disappeared.
I had previously installed and removed SQL 2005 Beta, so the only option
I had was to re-install connectivity to SQL 2005 and use "SQL Native
Client"
It looks like a re-build.
I've seen a few posts like this but never any response.
yay.
In article <u8fOB7fFFHA.4016@.TK2MSFTNGP09.phx.gbl>,
sxcostanzo@.hotmail.com says...
> Data source name not found and no default driver specified
> This is the error I get when attempting to install my copy of SQL Server
> 2000 developer edition.
> I had SQL Server installed on my workstation, functioning correctly. My
> computer crashed and it appears that there is some sort of registry
> corruption because I could not open up my local instance in Enterprise
> Manager.
> Checking ODBCAD32, it did not appear that I had any drivers installed for
> any source (MS Access, standard ODBC, SQL Server, etc.)
> I attempted to execute the MDAC on the Microsoft web site with no results.
> The component Checker determined that I had MDAC 2.8 SP1 on Windows XP SP2
.
> I uninstalled and reinstalled SQL Server and on the final step, the above
> message appeared.
> How do I get the default SQL Server driver reinstalled to my workstation.
My
> network techs indicate that I have to reinstall my OS to get the drivers
> back. This seems a little extreme.
> Thank you in advance.
>
>

Data source name not found and no default driver specified

On the database server, when I try to connect my SQL Server registration, I
get the error on the subject line. WHen I check my SQL Server Services using
SQL Server Services Manager, I do not see my server name in the drop down bo
x
- I have to type it in. SQL Server Agent and server services are started. My
jobs failed because of the error. I have never had to set up a DSN on the
server to get a connection to the database. PLease help to resolveHmmm...Is this a clean installation, an upgrade, etc...
Might be related (and I emphasize might) to MDAC. Check out:
http://support.microsoft.com/?kbid=301202
and
http://www.microsoft.com/downloads/...&displaylang=en
HTH
Jerry
"spoons" <spoons@.discussions.microsoft.com> wrote in message
news:CD4E905C-F6B5-4B1F-A1F8-8D205580DB35@.microsoft.com...
> On the database server, when I try to connect my SQL Server registration,
> I
> get the error on the subject line. WHen I check my SQL Server Services
> using
> SQL Server Services Manager, I do not see my server name in the drop down
> box
> - I have to type it in. SQL Server Agent and server services are started.
> My
> jobs failed because of the error. I have never had to set up a DSN on the
> server to get a connection to the database. PLease help to resolve
>

Data Migration

Transfering SQL database into Acess.
Problmes:
1. Identity column is not getting converted automitaclly into AutoNumber.
2. Default Value not retained.
is there any way out to get this.What version of SQL Server and Access are you using? Also what process of converting the data are you using??|||hi
i am using SQL server 2000, Access 2000.
nilesh