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 Purging

Hi

We have a requirement for purging the historical data based on the specified criteria.We have a complex data model with Parent Child Hirearchy goes to multiple levels.

Does any body knows information on how data purging is done in production environments with characteristics such as

Data Volume is huge (500 GB)

Multiple level of realtionships (It can go up to 6 levels)

Physical relationship exists between tables

thanks in advance :)

Regards
Samsudeen B

My 20 cents worth:

One of the reasons data purging may be a pain is the dilemma of associated indexes. You need them to locate the records to delete and they can make the whole process slow because they may have to be rebuilt (not forgetting any locking issues).

The other issue would be whether you have cascading referential integrity set up.

I would not embark on an all-at-once deletion. I would do small/medium range deletions and I might also disable any indexes on the underlying tables. I you have cascading referential integrity, all you have to do is just delete the relevant parent records.

DELETE FROM parent_table

WHERE date_column BETWEEN a AND b

GO

DELETE FROM parent_table

WHERE date_column BETWEEN b AND c

GO

.......................

........................

DELETE FROM parent_table

WHERE date_column BETWEEN y AND z

|||

Hi Nathan,

Thanks for the response.

I don't have the cascading referential integrity setup in my model.As I told earlier my model is complex with child tables been refered with multiple foreign keys..

Do you have any idea on how these kind of situations handled in pruging data in production environment.

Thanks,

Samsudeen B

|||

Without cascading referential integrity, you will have to delete data in the correct order to avoid constraint violations. Another headache.

Anyway, in a production environment, you will have to be much more cautious as it is very easy to slow down the server to a crawl due to table locking and excessive transaction log growth.

Here is what I have done before:

1. Script out the DROP and CREATE index statements for the tables concerned.

2. Script out the DROP and CREATE foreign key constraints for all child tables.

3. Make a script containing piece-meal delete statements (deleting a few thousand rows per table per batch starting with the child tables first). You need to understand the dependencies between your tables

During my "off-peak" hours

4. Change the database recovery model to "simple"

5. Disable all Triggers on the tables.

6. Drop the indexes and foreign keys (all in a script)

7. Run the "delete" script. Delete as many rows as possible within my "free" time window.

8. Enable the triggers

9. Run the script to recreate the indexes for the tables

10. Shrink the log file (DBCC SHRINKFILE)

11. Revert to "Full" Recovery model

12. Run a script to update statistics on the tables.

You don't have to delete all the data all at once. You can do this as many times as necessary if you have a very busy server. And you can put all that work (4-12) into a script and make some coffee. My server is not used for at least 4 hours in the night.

If your server never "chills out" then a carefully scripted delete operation and a simple recovery model may be of help. You may also save yourself a few headaches by adding cascading referential integrity to the tables. That way you script only the delete statements for the parent tables.

Data for source column is too large for the specified buffer size...

Hello there,

I have and small excel file, which when I try to import into SQl
Server will give an error "Data for source column 4 is too large for
the specified buffer size"

I have four columns in the excel file, one of the column contains a
large chunk of data so I created a table in SQL Server and changed the
type of the field to text so I could accomodate this field but still
no luck.

Any suggestions as to how to go about this.

Thanks in advance,
Srikanth paispai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> Hello there,
> I have and small excel file, which when I try to import into SQl
> Server will give an error "Data for source column 4 is too large for
> the specified buffer size"
> I have four columns in the excel file, one of the column contains a
> large chunk of data so I created a table in SQL Server and changed the
> type of the field to text so I could accomodate this field but still
> no luck.
> Any suggestions as to how to go about this.
> Thanks in advance,
> Srikanth pai

How are you importing? bcp, dts or what?
We are currently using bcp to import text fields without any problems.
I have used also used dts for importing text fields in the past.|||PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > Hello there,
> > I have and small excel file, which when I try to import into SQl
> > Server will give an error "Data for source column 4 is too large for
> > the specified buffer size"
> > I have four columns in the excel file, one of the column contains a
> > large chunk of data so I created a table in SQL Server and changed the
> > type of the field to text so I could accomodate this field but still
> > no luck.
> > Any suggestions as to how to go about this.
> > Thanks in advance,
> > Srikanth pai
> How are you importing? bcp, dts or what?
> We are currently using bcp to import text fields without any problems.
> I have used also used dts for importing text fields in the past.

Hello there,

I am using DTS to import the excel file...

Thanks,
Srikanth Pai|||spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > Hello there,
> > > > I have and small excel file, which when I try to import into SQl
> > > Server will give an error "Data for source column 4 is too large for
> > > the specified buffer size"
> > > > I have four columns in the excel file, one of the column contains a
> > > large chunk of data so I created a table in SQL Server and changed the
> > > type of the field to text so I could accomodate this field but still
> > > no luck.
> > > > Any suggestions as to how to go about this.
> > > > Thanks in advance,
> > > Srikanth pai
> > How are you importing? bcp, dts or what?
> > We are currently using bcp to import text fields without any problems.
> > I have used also used dts for importing text fields in the past.
> Hello there,
> I am using DTS to import the excel file...
> Thanks,
> Srikanth Pai

Pai,

Some suggestions for you.

(1) Try using bcp.
(2) Try with a manually created file and see if you can work out the
differences between your sample file and the prblem file. It maybe
some data, eg quotes or control chars that are
(3) Send me email containing your schema and a sample data file
(cutdown to the 2meg hotmail limit) and I'll have a look.|||PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401121321.7bae3a6e@.posting.google.com>...
> spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> > PromisedOyster@.hotmail.com (Mystery Man) wrote in message news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > > spai@.immunetolerance.org (Pai) wrote in message news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > > Hello there,
> > > > > > I have and small excel file, which when I try to import into SQl
> > > > Server will give an error "Data for source column 4 is too large for
> > > > the specified buffer size"
> > > > > > I have four columns in the excel file, one of the column contains a
> > > > large chunk of data so I created a table in SQL Server and changed the
> > > > type of the field to text so I could accomodate this field but still
> > > > no luck.
> > > > > > Any suggestions as to how to go about this.
> > > > > > Thanks in advance,
> > > > Srikanth pai
> > > > How are you importing? bcp, dts or what?
> > > We are currently using bcp to import text fields without any problems.
> > > I have used also used dts for importing text fields in the past.
> > Hello there,
> > I am using DTS to import the excel file...
> > Thanks,
> > Srikanth Pai
>
> Pai,
> Some suggestions for you.
> (1) Try using bcp.
> (2) Try with a manually created file and see if you can work out the
> differences between your sample file and the prblem file. It maybe
> some data, eg quotes or control chars that are
> (3) Send me email containing your schema and a sample data file
> (cutdown to the 2meg hotmail limit) and I'll have a look.

Thanks promised one for everything, what I did here was saved the
excel file as a .txt file and then imported the file sucessfully, I
have never tried bcp?

Thnaks,
Srikanth|||Pai wrote:
> PromisedOyster@.hotmail.com (Mystery Man) wrote in message
news:<87c81238.0401121321.7bae3a6e@.posting.google.com>...
> > spai@.immunetolerance.org (Pai) wrote in message
news:<5332f465.0401120742.d8bf3a4@.posting.google.com>...
> > > PromisedOyster@.hotmail.com (Mystery Man) wrote in message
news:<87c81238.0401111336.1216eb23@.posting.google.com>...
> > > > spai@.immunetolerance.org (Pai) wrote in message
news:<5332f465.0401101239.441dc621@.posting.google.com>...
> > > > > Hello there,
> > > > > > > > I have and small excel file, which when I try to import into
SQl
> > > > > Server will give an error "Data for source column 4 is too
large for
> > > > > the specified buffer size"
> > > > > > > > I have four columns in the excel file, one of the column
contains a
> > > > > large chunk of data so I created a table in SQL Server and
changed the
> > > > > type of the field to text so I could accomodate this field
but still
> > > > > no luck.
> > > > > > > > Any suggestions as to how to go about this.
> > > > > > > > Thanks in advance,
> > > > > Srikanth pai
> > > > > > How are you importing? bcp, dts or what?
> > > > We are currently using bcp to import text fields without any
problems.
> > > > I have used also used dts for importing text fields in the
past.
> > > > Hello there,
> > > > I am using DTS to import the excel file...
> > > > Thanks,
> > > Srikanth Pai
> > Pai,
> > Some suggestions for you.
> > (1) Try using bcp.
> > (2) Try with a manually created file and see if you can work out
the
> > differences between your sample file and the prblem file. It maybe
> > some data, eg quotes or control chars that are
> > (3) Send me email containing your schema and a sample data file
> > (cutdown to the 2meg hotmail limit) and I'll have a look.
>
> Thanks promised one for everything, what I did here was saved the
> excel file as a .txt file and then imported the file sucessfully, I
> have never tried bcp?
> Thnaks,
> Srikanth

FYI all, I had problems exporting to SQL from Access. So by exporting
to text (from access) and then to SQL using DTS...it worked!