ODBC Drivers error '80004005'

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?

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.