Site In MYSQL Server But Autoresponder In UNIX
Apr 14, 2008
HI...I wonder if anybody could assist my problem. I am very new to online. I have bought a DIY portal and hosting. It is on SQL server.
I wanted to do a lead capture page and put an Autoresponder to it. I bought AD 2019 and Porfit Sponder, but it's requirement is UNIX operating system.
1. Can I link the AR(needs UNIX) to my site on SQL ?
2. Does it need a device to translate any data ?
Regards,
Lena
Money is in the lists...where did my money go?
http://simurl.com/more-E-GOLD
http://simurl.com/Top3Percent
View 4 Replies
ADVERTISEMENT
Sep 13, 2007
First, let me start by saying I know the answer to this, but due to politics any answer I give will be viewed with some disdain and disbelief.
A Unix/Network [rtdpmin one our sister agencies is trying to solve a problem that really does not need to be solved, but ....
The sister agency uses Information Builder's WebFocus on Unix. When they try to read my data warehouse in SQL Server 2000 it times out on them (on their end and they claim they cannot fix it) (This is using the supplied WebFocus ODBC/JDBC driver for SQL Server). This has lead to accusations of us not letting them read the data.
After much gnashing of teeth over "if you do data and data analysis for a living, why do I have to show you how to set-up an ODBC connection" we have shown them how to connect to the data, read it, and transfer it using MS-ACCESS, EXCEL, and more importantly SPSS. This is not good enough because they cannot figure out how to put it into WebFocus.
Their network person has come-up with the brilliant idea of reading the .mdf directly by installing Windows for Unix on the Unix side and then just pointing to the .mdf file and "reading it ".
Unless I have missed something somwhere (I will admit possible), I know you need a driver to read MS-SQL and that driver in every example I have seen could care less about the physical location of the .mdf file. It wants to know what database, what server (ip or name) and what security/login to use.
Could someone give me a more "technical answer" or even Microsoft's party line so I do not have this person mucking around with my production server trying to acomplish the impossible.
View 5 Replies
View Related
Feb 12, 2007
Good Morning
Has anyone successfully used cherry's oledb provider for MYSQL to create a linked server from MS SQLserver 2005 to a Linux red hat platform running MYSQL.
I can not get it to work.
I've created a UDL which tests fine. it looks like this
[oledb]
; Everything after this line is an OLE DB initstring
Provider=OleMySql.MySqlSource.1;Persist Security Info=False;User ID=testuser;
Data Source=databridge;Location="";Mode=Read;Trace="""""""""""""""""""""""""""""";
Initial Catalog=riverford_rhdx_20060822
Can any on help me convert this to corrrect syntax for sql stored procedure
sp_addlinkedserver
I've tried this below but it does not work I just get an error saying it can not create an instance of OleMySql.MySqlSource.
I used SQL server management studio to create the linked server then just scripted this out below.
I seem to be missing the user ID, but don't know where to put it in.
EXEC master.dbo.sp_addlinkedserver @server = N'DATABRIDGE_OLEDB', @srvproduct=N'mysql', @provider=N'OleMySql.MySqlSource', @datasrc=N'databridge', @catalog=N'riverford_rhdx_20060822'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'DATABRIDGE_OLEDB', @optname=N'use remote collation', @optvalue=N'false'
Many Thanks
David Hills
View 7 Replies
View Related
Jun 20, 2001
I am very new to this board and I am not sure whether the following question belongs to this board. I will ask it anyway.
Can someone tell me where (book or web site or an example) I can go to learn how to be able to connect to a SQL Server database in a unix (in my case Solaris) environment using C/C++. I have been doing database programming using Oracle, Acess on NT with C/C++/ODBC comfortabley. I just need to learn how to go about in a Unix environment.
Wango
View 1 Replies
View Related
Apr 23, 2008
Are there any tools for installing SQL Server on a unix machine? (It seems to me like 6.5 might have been the last version that worked on unix?)
View 4 Replies
View Related
Feb 24, 2004
Has anyone tried to connect to a SQL Server 2K running on Windows 2000 from a unix machine? If so then could you provide me some help?
Thanks in advance
View 2 Replies
View Related
Apr 11, 2008
I have UNIX application, running on AIX, SUN and HP, (RISC & Itanium).
This application working with Oracle, via OCI, and OCCI, (I can use ODBC as well).
I would like replace Oracle with SQL-Sever.
Does there is a way/driver to access MS-SQL Server from Unix?
View 5 Replies
View Related
Jan 11, 2007
We are running SCO Unix 5.0.5. We need a command line sql client that can connect to a MS SQL server running on a windows server. Can someone point me in the right direction? I don't want to write a sql client. I just want a command line sql client binary that is ready to work.
I want to do something like this in a unix shell script:
# sql -s 10.1.2.3 -u username -p password -f sqlcommandsinafile.txt -o sqlresults.txt
Any help would be appreciated....
View 1 Replies
View Related
Apr 12, 2008
Hi,
My program is running on UNIX, (SUN, AIX and HP), and work with Oracle.
I would like to use SQL-Server instead of Oracle, but the program must run on UNIX.
Is there is a way/driver to work with SQL-Server from UNIX?
*new in SQL-Server area...
Thanks
View 5 Replies
View Related
Mar 3, 2005
I have an internal Project Management and Scheduling app that I wrote internally for my company. It was written to use MySQL running on a Debian server, but I am going to move it to SQL Server 2000 and integrate it with our Accounting software. The part I am having trouble with is the user login portion. I previously used this:
PHP Code:
$sql = "SELECT * FROM users WHERE username = "$username" AND user_password = password("$password")";
Apparently the password() function is not available when accessing SQL Server via ODBC. Is there an equivalent function I could use isntead so the passwords arent plaintext in the database? I only have 15 people using the system so a blank pwd reset wouldn't be too much trouble.
View 7 Replies
View Related
Apr 5, 2001
Hello !
I am owrking in java developmenton solaris using weblogic6.0
Does any body know how to access sql server data from solaris.
If some body knows that, can you please post me the steps
that i need to do it.
Thanks
Veena
View 3 Replies
View Related
Feb 6, 2004
Is it possibel to run a DTS job to read a file from unix server?
View 4 Replies
View Related
Oct 27, 2014
I've got a question about the UNIX timestamp solutions, I am using this one:
select convert(datetime, switchoffset(convert(datetimeoffset, dateadd(second, start_date, '19700101')), datename(TzOffset, sysdatetimeoffset())))
from x
This works great for today (wintertime), but when I query the past, say last week, it will still hold the current offset of my server GMT+1, where it was GMT+2.
Is there a way to get always the right date/time from a sql-query?
View 0 Replies
View Related
Jul 20, 2005
Hi,I am having a problem accessing SQL Server 2000 via UNIX. I amaccessing SQL Server 2000 from Solaris using Sybase Open Client(CT-Lib). Here is the error message:CT-LIBRARY error:ct_connect(): network packet layer: internal net libraryerror: Net-Library operation terminated due to disconnectI have another SQL server 6.5 and I do not have any problems accessing6.5 using the same strategy. Can someone tell me how I shouldconfigure to access SQL Server 2000 from UNIX?Thanks,Amy
View 1 Replies
View Related
Jul 20, 2005
Hi, everyone!I was just wondering if any of you knows of a linux/unix client(preferably on the command line) that would connect to ms sql server?Any hints would be appreciated!Roumen.
View 1 Replies
View Related
Jan 18, 2008
I have a windows server 2003 R2 sharing a filesystem using NFS. I have created a group and passwd file and mapped the ids' to the unix login ids' . I', able to mount but when I try to cd to the directory I get "NFS access failed for server testsrvr: RPC: Authentication error". On the win2k3 server I'm getting an event error "There was a mapping failure". I have the Admin id on the win2k3 server mapped to the unix root login .
View 1 Replies
View Related
May 8, 2007
I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup.
Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB.
Have these initial questions..
Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc
Any Input / Direction is appreciated...
View 4 Replies
View Related
Oct 12, 2001
Hello,
How can I assign the ODBC Database(Progress) on UNIX as publisher and SQL Server as subscriber. When I use the Enterprise Manager, I cannot see the Unix Server. I just can see the server and database in DTS.
Would you please explain the steps?
Alice
View 2 Replies
View Related
Jun 8, 1999
Hello,
I am trying to connect to a Microsoft SQL Server 7.0 from a SCO box (version 3.2v4.2)using sisql/bcp (sybase product). I can connect to a 6.5 database but when I try the same script to connect to 7.0 I get the following message: DB-LIBRARY error:
Unable to connect: SQL Server is unavailable or does not exist.
Is there anything I can do in order to fix this problem? Any ideas?
Thanks
View 1 Replies
View Related
Dec 6, 2014
I know that SQL Server runs on Windows Server, is it possible to download data in UNIX using shell script? does SQL Server has any binary or command line client for any operating system other than Windows?
View 5 Replies
View Related
May 9, 2001
I HAVE ONE COLUMN CONTAING THE INTEGER TYPE DATA COMING in UNIX DATE FORMAT. NEED TO CONVERT IT TO THE SQL SERVER DATE TIME FORMAT.
NOTE: UNIX IS STORING THE DATE IN SECONDS STARTING FROM 1970/1/1
ANYBODY CAN HELP ME TO SOLVE THIS PROBLEM.
e.g. The UNIX date time is 973101026 need to be converted to SQL DATE TIME
View 2 Replies
View Related
Jul 28, 2004
Anyone support a config where you have an unix/linux (AIX here) ODBC client connection to SQL Server database? I am looking for a simple, supportable configuration that does not require me to learn perl or instal a bunch of crap gnu shareware on enterprise class machines.
Please help!
View 2 Replies
View Related
May 17, 2007
Hi,
Is there as way to access SQL SErver DB for DML Operations from C++ programs in UNIX/LINUX. The current approach is by uisng Pro C to connect to ORACLE from C++. But I want to connect to SQL Server 2005.
Regards,
Kart
View 3 Replies
View Related
Jul 20, 2005
Anyone support a config where you have an unix/linux (AIX here) ODBCclient connection to SQL Server database? I am looking for a simple,supportable configuration that does not require me to learn perl orinstal a bunch of crap gnu shareware on enterprise class machines.Please help!
View 3 Replies
View Related
Dec 6, 2006
Hi,
We are trying to move our application from SQL2005 to SQL2005, we are using 2005 jdbc driver 1.1.
The problem we have is, when a date is retrieved from the database, only the year part got correctly, but the date is automatically set to January 1 of that year. The interesting thing is this problem doesn't occur on local development environment (developer's windows platform), it only happens when we deploy the application to production server (unix).
Does anyone know what is going on, how to fix it?
Thanks.
Cathie
View 12 Replies
View Related
Apr 11, 2007
Hello,
I am upgrading my site from a VPS with a shared SQL server to a dedicated server and my own sql server 2003 standard. My site is an ecommerce site with about 10,000 users a month with between 10-20 people on the site at one time.
It is better to host both my site and the SQL server on the same system or is it better to have them on separate systems? if they are on the same system is 1 gig of ram enough? is will there really be much better performance with 2 gigs?
Any information on the best way to do this would be greatly appreciated!!!
Best regards,
~ Moe
View 2 Replies
View Related
Oct 2, 2000
Hi,
can anyone tell me how exactly sql server7 interacts with Site Server, LDAP.
I am a sql dba, trying to work with above ones. Anyone pls suggest me any book or material or ur ideas.
Thanks!
--Siva
View 1 Replies
View Related
Apr 30, 2004
hi all,
could anybody send me the tutorial site for learning sql server...
especially in stored procedure,functions,triggers.
thanx in advance
View 2 Replies
View Related
Jun 1, 2007
How to create DTD compatible XML file from result set returned from a query.
Can we access FTP site and upload this xml ?
Is it possible to do from Tsql?
View 2 Replies
View Related
Apr 10, 2006
Can someone show me, or direct me, to a source, that shows me how, and what to change, when deploying a website from a development server running Sql Ex to a production server running Sql server 2005. I can’t get the sites to run under Sql server 2005.
They work in Sql Ex. what must I change? The connection string, to what format? and what else? I attached the dB to Sql 2005 and browsed the content in the Sql manager. But can’t get the aspx pages to work on the server.
Help please
View 6 Replies
View Related
Jan 15, 2007
Would it be recommended to use SQL Server 2005 Compact Edition on a web site, if that site received very few requests per month?
View 1 Replies
View Related
Feb 11, 2006
Hello everybody!
Can anyone tell me what steps i should follow in order to get my web site (which is hosted with a web host in ireland) to connect to yet another server (different country) where SQL Server 2005 will be running?
Thank you! - Callam
View 1 Replies
View Related
Jan 9, 2007
I'm currently learning my way around with SQL Server 2005 and asp.net 2.0, and for this I wrote a little site that uses SQL Server for it's backend.
I developed it on my laptop, and it works great, until I deployed the website to my test server, so it's visible to the outside world.
The instance I try to access any page that invokes the database, I get the following error:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified).
The server doesn't differ much from my laptop setup, except that it accepts connections through named pipes and TCP/IP and has the Network Service as a user(I also tried running the website under Administrator privileges, just to test it out).
Both IIS and the SQL Server running on the same machine(Windows 2003 Server SP1), and the SQL server accepts connections from a locally running SQL Management Studio Express instance. However: It does not accept connections from my laptop, which resides outside the domain. The server is set to use Windows Authentication for log ins.
What am I doing wrong here?
EDIT: Filled out this found questionare:
[1] Client side:
What is the connection string in you app or DSN? (please specify) connectionString="Data Source=.SQLEXPRESS;Initial Catalog=EroSite;Integrated Security=True" providerName="System.Data.SqlClient"
If client fails to connect, what is the client error messages? Error Locating Server/Instance Specified
Is the client remote or local to the SQL server machine? LocalCan you ping your server? YesCan you telnet to your SQL Server? YesWhat
is your client database provider? ADO.NET2.0
Or/And, what is your client
application? Website using DataSets (Works fine with Server Management Studio)
Is your client computer in the same domain as the Server computer? Local machine
What protocol the client enabled? Shared Memory, TCPIP, Named Pipes.Do
you have aliases configured that match the server name portion of your
connection string? NoDo you select force encryption on server and/or client? No
[2] Server side:
What is the MS SQL version? SQL Server 2005What is the SKU of MS SQL? ExpressWhat
is the SQL Server Protocol enabled? Shared Memory | TCPIP | Named
Pipes
Does the server start successfully? YesIf SQL Server is a named instance, is the SQL browser enabled? YesWhat is the account that the SQL Server is running under? Local SystemDo
you make firewall exception for your SQL server TCP port if you want
connect remotely through TCP provider? not applicableDo
you make firewall exception for SQL Browser UDP port 1434? In SQL2000,
you still need to make firewall exception for UDP port 1434 in order to
support named instance. Not applicable
[3] Platform:
What is the OS version? Windows 2003 SP 1Do you have third party antivirus, anti-spareware software installed? No
View 7 Replies
View Related