ODBC Drivers error '80004005'

This is the following error that i get.

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

error in asp file line 82:

Here is what i do to establish connection. I use a system DSN, DSN was also supposedly created on the server-side as well.

Set xConn = Server.CreateObject("ADODB.Connection")
xConn.ConnectionString = "DSN=CMP2 Test"
xConn.Open strConn

What is the problem? I want to be able to establish a connection with this database on SQL Server.
LVL 1
mathew_sAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ralf KlattEmployee in Civil ServiceCommented:
Hi,

Where is the "strConn" variable declared?

Best regards, Raisor
0
mathew_sAuthor Commented:
Good question. Think it was one of my previous attempts to get the stupid thing to work. Forgot to take it out.  Thanks, however, after taking strConn out. I now have:

Set xConn = Server.CreateObject("ADODB.Connection")
xConn.ConnectionString = "DSN=CMP2 Test"
xConn.Open

I still get errors:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

error line 81

I also tried without putting "DSN=", just CMP2 Test...so I now had
Set xConn = Server.CreateObject("ADODB.Connection")
xConn.ConnectionString = "CMP2 Test"
xConn.Open   <--- line 81

Still  get the same error.
Also I tried the following:

set xConn = Server.CreateObject("ADODB.Connection")
DSNLog = "PROVIDER=MSDASQL;DRIVER={SQL Server}; "
DSNLog = DSNLog & "Server=STR02;"
DSNLog = DSNLog & "Database=CMP2;"
DSNLog = DSNLog & "Trusted_Connection=yes;"
xConn.Open DSNLog ' Open Recordset and get the field info  <--line 85

Get a different error now.

Microsoft OLE DB Provider for ODBC Drivers error '80040e4d'

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '\'.

error line 85

Database is called CMP2, system DSN is called CMP2 Test.
Hope this info. helps...Any suggestions?
0
Ralf KlattEmployee in Civil ServiceCommented:
Hi,

The last error you got tells that there's no user defined for the trusted connection! (MACHINENAME\USERNAME) for DOT.NET this is "MACHINENAME\ASPNET" -> this user should have dbo rights.

By the way -> if you have a SQL Server behind it (you are using the drivers!) why don't you connect directly to the database?

Make sure you have no typo in your DSN ... make sure your DSN "IS SYSTEM DSN"! Open the ODBC Manager to check this ... use the "TEST" option and run a connection test ... if all that is done and the test turned out to be successfull -> then you can be sure that your DSN works fine ... You should then replace "trusted connection" with an existing user name and password ...

Best regards, Raisor
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

sachinmerguCommented:
Dear sir,
while inputing data i am getting error are as follows:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'service' in database 'sims' because the 'PRIMARY' filegroup is full.

with regards
sachin
0
abaglaCommented:
I am getting the followin g error

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object 'TblDtlInsured' in database 'heritage' because the 'PRIMARY' filegroup is full.
0
MichaelSFullerCommented:
How big is tempdb?
 
0
MichaelSFullerCommented:
Is the web server and sql server the same box, same domain? If not how is this going to work? "MACHINENAME\ASPNET"
0
ChrisDennyCommented:
Problem is the ODBC configuration....

Go to that and verify that you have setup correctly...

In ODBC, the setting should exist under the "System DSN" tab and no other than that one.

Make sure domino server is correct and "Database" is correct.  Click on "Options" to make sure that browsed to the Notes.id file that you want to use (you will see the name of the employee that the file belongs to once selected) and enter the password for the notes account.

Let me know what is next...
0
ChrisDennyCommented:
By the way, this is what mine looks like if you are curious:

Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.ConnectionString = "DSN=Deskop"
oConn.Open
0
ChrisDennyCommented:
And the ODBC configuration is on the web server
0
meariskCommented:
I am trying this in excel. What reference should I be using.

Mark
0
ChrisDennyCommented:
In the ODBC configuration, use the System configuration. Then in Excel, you can import the information.
0
ChrisDennyCommented:
To import into Excel, you would go to the "Data" tab and select "Import External Data - Import Data".  Then, select "+Connect to New Data Source.odb", Next screen select "ODBC DSN" and then select the connection that you already made.
0
ChrisDennyCommented:
If the above doesn't help, please help me understand the current problem in detail and I will do my best to give better directions back to you.
0
ChrisDennyCommented:
Mearisk:
Please do me a favor and open a new ticket and reference that new ticket in here.  That way, I can get my points and help you out with this.  I hope you understand.  Just trying to follow the rules/politics of Experts Exchange site.

Thanks,

Chris Denny
0
CWilliamWallaceCommented:
Have you upgraded the system to MDAC 2.8?

Bill.
0
quocnhanCommented:
May be hack this erros
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.