ODBC Tip

[admin]

When setting up your ODBC in the control panle H-Sphere..


This would be the full path all ways the same..

C:\hshome\username\domain.com

Note: You can put your DB below the domain.com dir so no one on the web can download it.

So in the control panel you would put if its in your root web dir.
/username/domain.com/database.mdb

If its below the root web it would be
/username/somedir/database.mdb

Hope this helps..

[hohios]

for me it works ONLY as

domain.com/database.mdb

[flashweb]

In what there can be problems with SQL DSN?

I Have created DSN for mine MSSQL bases

Then I write a code:

Set db = Server.CreateObject("ADODB.Connection")
db.Open "DSN=mydsn;UID=MyID;PWD=Mypassword"

I receive a mistake (80004005)

=================
This is the error, which means it's not recognizing the DSN:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

Without DSN through OLEDB all works correctly.

[admin]

I know i found a bug in the ODBC setup the other day and reported it to Psoft.. It should be fixed in Ver. 2.3 due out with in a week or so..

[hohios]

ODBC doesn't work now.

[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.


Not surprised , cause every time I create a new account (in reseller admin) dsn doesn't work and I have to resubmit ODBC info. (????) But now this don't work

please check it

[hohios]

I solved the problem. The database was access '97 version, i converted to 2000 and it's ok now.

But I'll checkout again the second part of my previous post (that sais whenever I create an account to reselleradmin or a domain to any account , odbc fly away )

[matthewshull]

I am also having this problem, only mine is ODBC-less. Here is the error:

Microsoft JET Database Engine error '80004005'

Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.

I will open a ticket for this.