eduardo74
Technical User
- Aug 16, 2012
- 1
Anyone can help me with good connection string for connection via ODBC (already purchased ODBC driver v5) with TPS databases located on hard disk in folder: D:\APPLIC\2012
I used string:
Dim con As New OdbcConnection("Driver={SoftVelocity Topspeed driver (*.tps)};Dbq=D:\APPLIC\2012\;pwd=;extension=tps;oem=N;datefield=%date%;timefield=%time%;nullemptystr=N")
query1 = "SELECT customers.NAME FROM Customer.tps"
Dim com As New OdbcCommand(query1, con)
con.Open()
Dim rdr As OdbcDataReader = com.ExecuteReader
While rdr.Read()
.... ...
But after start reader I got ERROR [42000] [SoftVelocity Inc.][TopSpeed ODBC Driver]Unexpected extra token:
Please help!
Thanks in advance
I used string:
Dim con As New OdbcConnection("Driver={SoftVelocity Topspeed driver (*.tps)};Dbq=D:\APPLIC\2012\;pwd=;extension=tps;oem=N;datefield=%date%;timefield=%time%;nullemptystr=N")
query1 = "SELECT customers.NAME FROM Customer.tps"
Dim com As New OdbcCommand(query1, con)
con.Open()
Dim rdr As OdbcDataReader = com.ExecuteReader
While rdr.Read()
.... ...
But after start reader I got ERROR [42000] [SoftVelocity Inc.][TopSpeed ODBC Driver]Unexpected extra token:
Please help!
Thanks in advance