Database interface Wizard

D

Dan Greif

I am trying to connect to an MSSQL database. The Table I need to work with has a timestamp field. The Wizard fails when it connects to the table as that is an unsupported datatype
Quick solution use a view in MSSQL and leave that field out
But the wizard won't allow the creation of interface pages on a view

I guess the answer is my DB is can't be used with the wizar
 
N

Net55

You can do a view query, it will show up on the database
dropdown menu.

Try a custom query if you want the timestamp field, FP
will allow pure sql.

Net55
(e-mail address removed)
http://www.frontpagewiz.com
-----Original Message-----
I am trying to connect to an MSSQL database. The Table I
Click to expand...
need to work with has a timestamp field. The Wizard fails
when it connects to the table as that is an unsupported
datatype.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0
sqlite-odbc write conflict 2
Page numbering with Merged Document and IF statements 1
DATABASE INTERFACE WIZARD - has disappeared ! 2
Linked servers 5
importing from SQL Server 2008 Express 0
SQL - Database Interface Wizard 0
Database interface wizard problem 8

Top