User login

MetaTraffic 2.0 Boxshot

Does the CLASS file have connection string?

Posted by ivonda [August 12, 2003]

Hi there,

I have tried to let the Metatraffic v1300 to work but it doesn't work for me. What I am doing wrong can someone help me? What does the line 2786 say? The admin works fine for me.... but how can this be solved? (Does it have an connection string??):oops:

I get this error generated by the server:

Type d'erreur :
Microsoft JET Database Engine (0x80004005)
'\\userprof03\users\Database\db.mdb' n'est pas un chemin d'accès valide. Assurez-vous que le nom du chemin d'accès est correct et qu'une connexion est établie avec le serveur sur lequel réside le fichier.
/traffic/class.asp, line 2786

Does the CLASS file have connection string?

Hi,

The error 80004005 is a very general error number so it would help me if the error message was in english. (My french is not very good when it comes to technical terminology.) Maybe someone could translate this?

Thanks,
~Chad

Does the CLASS file have connection string?

Ivonda,

The message states that the path is invalid.

I'm not sure if UNC is supported for database connection.

Will need to investigate on that one.

One possible workaround would be to assign a drive letter pointing to the directory on the workstation where the db resides, then use that letter on the connection string.

For instance :

1) Net use X: \\userprof03\users /YES
- This command would be executed at your system startup.

2) strcon=...;DBQ=X:\databases\db.mdb"

Or

Create a System Dsn and use the corresponding name in your connection string. I'm not really an ODBC fan, but if you don't have the choice, that might be the route to go, although with some expense at the performance and fonctionality levels.

Have fun...

You may consider to consult this link :

http://www.able-consulting.com/ADO_Conn.htm

If you don't find your answer there, I dunno where else it could be found!

Got it!

strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=\\myServer\myShare\myPath\myDb.mdb"

Does the CLASS file have connection string?

UNC paths are supported. I would make sure that your database path is correct.

Regards,
~Chad