RE: Datasource question
So...should I go with the ODBC connection to Pervasive SQL or try to connect to Pervasive via linked server in SQL 2005 Express, or am I barking up the wrong tree? -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 8:04 AM To: CF-Talk Subject: Datasource question I have a brand new intranet server with Blue Dragon and SQL Server 2005 Express. I need it to connect to a Pervasive SQL database on another server so I can put this thing to work. I have configured an ODBC datasource for the Pervasive SQL connection. Is it better or even possible to configure the connection using a linked server in SQL 2005 instead? The Pervasive connection is critical since it contains reporting data. Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292316 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Datasource question
Do they have a JDBC driver for Pervasive SQL? Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Billy Cox wrote: So...should I go with the ODBC connection to Pervasive SQL or try to connect to Pervasive via linked server in SQL 2005 Express, or am I barking up the wrong tree? -Original Message- From: Billy Cox [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 8:04 AM To: CF-Talk Subject: Datasource question I have a brand new intranet server with Blue Dragon and SQL Server 2005 Express. I need it to connect to a Pervasive SQL database on another server so I can put this thing to work. I have configured an ODBC datasource for the Pervasive SQL connection. Is it better or even possible to configure the connection using a linked server in SQL 2005 instead? The Pervasive connection is critical since it contains reporting data. Thanks, Billy Cox Old World Spices [EMAIL PROTECTED] ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292320 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Datasource question
Billy Cox wrote: So...should I go with the ODBC connection to Pervasive SQL or try to connect to Pervasive via linked server in SQL 2005 Express, or am I barking up the wrong tree? Depends on which Pervasive you are talking about. If you mean the one that started life as BTrieve I would try the linked server approach. If you mean the one that started life as PostgreSQL I would try to connect directly to it with a PostgreSQL JDBC driver (the product is only rebranded, not actually changed). Jochem ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292321 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Datasource question
This is the Pervasive formerly known as bTrieve. I am running the free edition of BlueDragon Server, so JDBC is not an option. Pervasive's ODBC driver seems to have a problem with transaction management or locking when doing inserts/updates so I am hoping that I can find a way around ODBC. -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 8:03 AM To: CF-Talk Subject: Re: Datasource question Billy Cox wrote: So...should I go with the ODBC connection to Pervasive SQL or try to connect to Pervasive via linked server in SQL 2005 Express, or am I barking up the wrong tree? Depends on which Pervasive you are talking about. If you mean the one that started life as BTrieve I would try the linked server approach. If you mean the one that started life as PostgreSQL I would try to connect directly to it with a PostgreSQL JDBC driver (the product is only rebranded, not actually changed). Jochem ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292323 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: datasource question
The hostname is actually the datasource name. This is usually chosen by the hosting company so you will need to contact them and ask them what the datasource name is. You will also want to check and verify that you are using username and password. In any case when you've figured it out, your CFQUERY tag will look something like this: cfset Username="MyUsername" cfset Password="PaSsw0rD" cfset Datasource="MyDatasourceName" cfquery name="members" datasource"#Datasource#" username="#Username#" password="#Password#" /cfquery Some ColdFusion hosts will set it up in a manner that you will not need to provide the username/password in each of your CFQUERY tags. This is dependent on the ColdFusion host so you should check with them to see if this is the case. Benjamin S. Rogers Web Developer, c4.net voice: (508) 240-0051 fax: (508) 240-0057 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 07, 2001 12:29 AM To: CF-Talk Subject: datasource question I am new to coldfusion and have my site internetcraftfair.com that doesn't have coldfusion on the server. The sister of my server has coldfusion and has been kind enough to set me up a temporary location so I can code some pages for possible employment. Well I have coded the page and sent it up to the sister server but I am not sure how to point it to access my database on my site's server. I have been using perl to connect to my database on my site with DBI and I make a database string that I send to the server in a variable. I have tried to form a database type of string with the CFSET functions setting the username, password, and hostname. I am not sure of the syntax of it though or if I am suppose to use my site "internetcraftfair.com" as the host or the server "topchoice.com". To access my database on my server through telenet my root folder on internetcraftfair.com is client/home/internetcraftfair and then I type in mysql to access the database and send my username and password in to access it. cfset username="name" cfset password="password" cfset hostname="???" should this be internetcraftfair.com or do I need to specify my root directory ? cfquery name="members" datasource" #hostname#,internetcraftfair,#name#,#password#" do I use commas or colons in this string? I am having a hard time accessing the temp folder on the web and hope to hear back from radiant in the morning so I can view my code on the web. I would appreciate any help on this you can suggest. Thanks-- Shelly Hill http://www.internetcraftfair.com "All our dreams can come true - if we have the courage to pursue them" -Walt Disney ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists