 04-03-2008, 3:09 PM
|
zoomprint
Joined on 04-04-2008
Posts 1
|
Connection problems with ASP.Net (Vb) and ODBC .tps
|
|
|
|
|
Hi,
I currently connect to my tps via ASP, IIS and the .Tps Odbc driver but I would like to convert my website to ASP.net but I cannot get the connection string to work. This is the connetion via asp.
dim xpath
dim strConnect
'-------------------------------------------------------------------------\
xpath = "filepath" 'trailing \ is required for TPS files
strConnect = "DRIVER=SoftVelocity Topspeed Driver (*.tps);DBQ=" & xpath & ";"
'note: after any error, you may have to restart MSIE and/or IIS
'-------------------------------------------------------------------------/
dim QPConn
Set QPConn = Server.CreateObject ("ADODB.Connection")
QPConn.CursorLocation = 3
QPConn.Mode = 3 'adModeRead/Write
QPConn.Open strConnect
%>
but this is not supported in asp.net
I am currently using this
<script language="vb" runat="server">
sub Page_Load(sender as Object, e as EventArgs)
Dim connString as String
connString = "PROVIDER=SoftVelocity Topspeed Driver (*.tps);DBQ=filepath"
'Open a connection
Dim objConnection as OdbcConnection
objConnection = New OdbcConnection(connString)
objConnection.Open()
but I get errors. Can anyone help me as I you may see I am quite new to all this.
|
|
|
|
|
Report
|
|
|
|