|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Problem with DSN connection |
|
From: |
Frankie |
|
Date: |
5/31/2000 1:29:53 PM |
|
IP: |
203.134.24.180 |
Can anyone teach me how to connect to MS Access?
Im just using a dial up network with my NT server 4,
but my internet provider does support ASP in there
server. I tried to work with Access and it was work
in my computer, because it is local, so it can find
the path of my database (DSN). However, whenever I
upload it to the server, they always says path error
something like that. The error message is:
Microsoft OLE DB Provider for ODBC Drivers error 80004005
General error: Invalid file dsn users.dsn
/download.asp, line 15
why? The code Im using is:
set objConn=Server.CreateObject("ADODB.CONNECTION")
objConn.Open "FILEDSN=users.dsn"
SQLstring = "INSERT INTO users (UserName, Email) values
(" & strName & ", " & strEmail & ");"
objConn.Execute(SQLstring )
Can someone told me to create
same DSN in server, but how? please help
thanks and regards
Frankie
email: fyip@iprimus.com.au
|
Follow Up - Re: Problem with DSN connection - NIck 6/13/2000 8:26:14 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
