Information générale
Catégorie:
Active Server Page
Titre:
DNSless Connections in InterDev ans using DTC's
I need to create a DSNlsess connection in InterDev 6.0. I have a DSNless connection in my global.asa file which works fine. However, I would like to use DTC's but can't get the string to work, when I set it up it puts in a path to my data despite the fact I use Serve.Mappath. here is my connection string I use...
Sub Application_OnStart
set ConStr = Server.CreateObject("ADODB.Connection")
ConStr = "DRIVER=Microsoft Visual FoxPro Driver;"
ConStr = ConStr & "BackgroundFetch=Yes;"
ConStr = ConStr & "Exclusive=No;"
ConStr = ConStr & "SourceType=DBC;"
theDatabase = server.mappath("\MyProject\data\inventory.dbc")
ConStr = ConStr & "SourceDB="&theDataBase
Application("connectionString") = ConStr
end Sub
This works fine but I would like to add a Dataconection so I can utilize the DTC's (design tme controls).
I have MDAC 2.6 and the lastest Jetengine installed. I am using WINNT 4.0 service pack 6a with the NTOption pack.
Any ideas would be helpful. I can set up a DSNless connection on my machine and it works fine ut since it "hardcodes" the path to my a data it does not work on my ISP's server. Please HELP I have a deadline I really need to meet.
Thanks in advance
Mike Cox
zorfox@acceleration.net
PS: Email would be appreciated so I will know when I get a response. I will be up all night trying to get this working. Example would be great too (that enaough requests *GRIN*
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement