Re: connect to MS SQL Server via ODBC
Hi Robert, Typically when requesting 'user' table information from MS SQL Server, you want define the SELECT statement as: SELECT * FROM sysobjects WHERE (xtype = 'U') Look at the 'syscolumns' table for the column names and their properties - length, type, etc. Mark Stuart Robert Eppich wrote: Hello All, I am trying to get a list of the table names from an SQL Server. By using the following script: put RevDataFromQuery(,,line 1 of fld 1,select name from sys.tables) These tablenames are returned. spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_values However, this is not what I expected to see. It seems as though the tables are one level deeper in dbo and then Tables, at least this is how Crystal Reports displays it. I'm looking for a specific table called Labor_Ticket. I have used the Database Query Builder tool in Rev and the tables listed are the same. How do I get another level deeper to the actual tables I'm looking for. Thanks for any ideas. Rob ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/connect-to-MS-SQL-Server-via-ODBC-tf4564371.html#a13042798 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
connect to MS SQL Server via ODBC
Hello All, I am trying to get a list of the table names from an SQL Server. By using the following script: put RevDataFromQuery(,,line 1 of fld 1,select name from sys.tables) These tablenames are returned. spt_fallback_db spt_fallback_dev spt_fallback_usg spt_monitor spt_values However, this is not what I expected to see. It seems as though the tables are one level deeper in dbo and then Tables, at least this is how Crystal Reports displays it. I'm looking for a specific table called Labor_Ticket. I have used the Database Query Builder tool in Rev and the tables listed are the same. How do I get another level deeper to the actual tables I'm looking for. Thanks for any ideas. Rob ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Connect to MS SQL Server via ODBC on Mac OSX
Hello All, I have downloaded and installed the Actual Technologies ODBC drivers and configured them with ODBC Administrator application under Mas OS X 10.4.10. I have also verified that Revolution on Windows XP will open and close the SQL Server using ODBC. When setting up the Mac in ODBC Administrator for the Actual Technologies drivers, I'm asked Which SQL Server do you want to connect to? (The server is typically referred to by its IP address). The information on the Windows XP is DA08. I have used DA08 instead of the IP address for the SQL Server, but when trying to use RevOpenDatabase() the error message Data Source Name not found. is what is returned. No one could tell me IP address of the SQL Server, is this the information I need? Why can't Mac OS X use DA08 instead of the IP? Is the IP address the simple answer? (Just trying to connect Rev on Mac to MS SQL Server via ODBC. If you have experience I'd love to hear from you) Thanks Robert Eppich ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
Re: Connect to MS SQL Server via ODBC on Mac OSX
Hi Robert, Is DA08 the SQL Server computer name? To get the IP address of the SQL Server, use ping DA08 (without the double quotes) from the DOS prompt. Mark Robert Eppich wrote: Hello All, I have downloaded and installed the Actual Technologies ODBC drivers and configured them with ODBC Administrator application under Mas OS X 10.4.10. I have also verified that Revolution on Windows XP will open and close the SQL Server using ODBC. When setting up the Mac in ODBC Administrator for the Actual Technologies drivers, I'm asked Which SQL Server do you want to connect to? (The server is typically referred to by its IP address). The information on the Windows XP is DA08. I have used DA08 instead of the IP address for the SQL Server, but when trying to use RevOpenDatabase() the error message Data Source Name not found. is what is returned. No one could tell me IP address of the SQL Server, is this the information I need? Why can't Mac OS X use DA08 instead of the IP? Is the IP address the simple answer? (Just trying to connect Rev on Mac to MS SQL Server via ODBC. If you have experience I'd love to hear from you) Thanks Robert Eppich ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution -- View this message in context: http://www.nabble.com/Connect-to-MS-SQL-Server-via-ODBC-on-Mac-OSX-tf4551152.html#a12988892 Sent from the Revolution - User mailing list archive at Nabble.com. ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution