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*