|
|
|
|
|
| | |
| |
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program 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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
