Link to home
Start Free TrialLog in
Avatar of mathew_s
mathew_s

asked on

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.
Avatar of Ralf Klatt
Ralf Klatt
Flag of Germany image

Hi,

Where is the "strConn" variable declared?

Best regards, Raisor
Avatar of mathew_s
mathew_s

ASKER

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?
ASKER CERTIFIED SOLUTION
Avatar of Ralf Klatt
Ralf Klatt
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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.
How big is tempdb?
 
Is the web server and sql server the same box, same domain? If not how is this going to work? "MACHINENAME\ASPNET"
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...
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
And the ODBC configuration is on the web server
I am trying this in excel. What reference should I be using.

Mark
In the ODBC configuration, use the System configuration. Then in Excel, you can import the information.
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.
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.
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
Have you upgraded the system to MDAC 2.8?

Bill.
May be hack this erros